Different Drop Down Lists in Same Excel Cell

[37no37]

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

[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.