Excel Single Use Dropdownlist

Question

My problem is the following. I have two tables. The first table is a guest list where the information on who is the guest and how many beds he need is stored. Screenshot And the second table contains the Apartment names and the number of provided beds. Now I want to make a dropdown list in the guest list table where only Beds are shown that provide the right amount of beds. And after a Apartment is selected it cant be picked a second time. Can someone provide me a code for this solution? Thank you very much!

Answer 1

There is functionality in Excel to use Dropdowns, to do this you need to identify your drop down requirements as shown below. Only include items the dropdown list if these not going to change.

I recommend to create a new tab in your excel workbook for list, then you can reference this in cell you want -https://support.microsoft.com/en-us/office/video-create-and-manage-drop-down-lists-28db87b6-725f-49d7-9b29-ab4bc56cefc2

Dropdown list

Guest 1

Guest 2

Guest 3

Assumptions:

Sound like you need know if bed a is available based off guest drop down list. If bed is available or not it can't be selected again. I will let you attempt this but you can try and use IF Statement or VLOOKUP.