Different Drop Down Lists in Same Excel Cell

http://www.contextures.com/xlDataVal02.html Select an item from an Excel drop down list, and see only the related items in the next drop down list. Limit the choices in an Excel data validation list, by using Excel named ranges and the INDIRECT function, to create dependent data validation lists. In this example, if a country is selected from the first drop down, only that country's cities appear in the next column's drop down list.
Also, you can use the Excel IF function to make the selection more flexible. If no country is selected, show a list of world cities in the dependent drop down list.

Category:

Science & Technology

Tags:

• Excel
• Excel tips
• data validation
• Excel data validation
• drop down arrows
• Excel Video tutorial
• Contextures

[LFR4]

Thanks for the great videos! They are great I'm learning alot.

Would it be possible to have a video on creating dependent drop downs from unsorted lists? The two Named lists bellow would allow a drop for Letter and Number if you click on Letter and select "A" Number would update to "1" or if the user selected Number as "3" Name would update to be "C".

Letter, {"A";"B";"C";"D"}, =Data!$B$2:$B$5

Number, {"1";"2";"3";"4"}, =Data!$A$2:$A$5

[contextures]

@LFR4 Thanks, I'm glad the videos are helping you.

For your example, will you have two lists, side by side, on the lookup sheet? Then, on the data entry sheet, if someone selects from the Number drop down, the only option in the Letter drop down is the Number in the same row in the other list?

If the Number cell on the data entry sheet is empty, the Letter drop down would show the full list of Letters.

[LFR4]

@contextures I found out that what I wanted would require me to create a VBA macro which I am currently doing. Thank for the response and willing to help.

[contextures]

@LFR4 Glad you found a solution, and thanks for letting me know.

[37no37]

combinatorial problem -- given the 24 numbers taken 5 at a time, which unique combinations add up to 200?