Forum Discussion
Dependent drop down lists
I would like to create a drop down list with multiple words
Do you mean you want one drop list with (say) A B C and a second drop down which would have A1,A2,A3 if A is selected; then B1,B2,B3 if B I’d selected and do on?
LA_Mitche11 Were you able to make a dependent drop down? If so could you share the steps. I think I have tried the same steps you mentioned.
I'm attaching a method of what I called "cascading" drop down or data validation lists. This simple demo is just based on first and last names....you can add combinations of first and last names to test the process. When you do, you'll notice that
- the list of unique first names grows as a new first name is added
- that list of unique first names is the basis for the drop downs in the first box, where you are invited to select a first name. That drop down list grows with each additional unique first name
- Once you've selected a first name, the list of unique last names that correspond to the selected first name is displayed and serves as the data validation list for the second drop down box.
This method makes use of the new Dynamic Array functions, UNIQUE, FILTER in particular. I also employ SORT so that the lists are shown in alphabetical order. But if you don't have the most recent version of Excel, you will not be able to use those functions, and therefore this method will not work.
