I have a sheet consisting of about 10 drop down lists (among other fields). I want to create a master drop-down list, which would populate some of the other drop-down lists and/or other fields based on the value chosen in the master list.
Would this be possible? Thanks!
EDIT
I appreciate all the answers! I think the solution from Werff may have answered my question, although I am having a little trouble getting it to work so I wanted to add more details to my question to make sure we are on the same page and also clarify with the other people answering.
In this example, Column A would be my master list. Columns B-D define dropdowns that would appear in other places on the sheet. If I select Steve from the master dropdown I would like the other dropdowns to all populate his preferences (for example Steve's House, Ground, and UPS). The same goes for the other people in the Shipping To field. Hopefully that makes the question more clear! Thanks!
Best Answer
Put a list of fruits in column C, a list of dogs in column D and a list of cats in column E. The DV dropdown in cell A1 will allow the user to select either "fruit" or "dog" or "cat".
In cell A2 we setup Data Validation with the List option and the formula:
Now if you pick a category in A1, cell A2 will show the items for that category !
From My Old Post