Excel Single Use Dropdownlist

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!

1 answer

  • answered 2022-05-06 11:18 Tehjpal Singh

    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.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum