Drop-down list dependant on another cell value

S

samdev

I want to create a drop-down list (using Data, Validation, selecting
List...) but the drop--down list that opens will be dependant on the
value of another cell.

For example:

In A1 the value "fruit" is entered and the drop-down list in B1 will
list fruit, but if "vegetable" is entered in A1 than a drop-down list
of vegetables will be displayed, if "meat" is entered in A1 then the
drop-down list will display a list of meat etc...

Right now there are 9 different options that could be entered in Column
A - this number may increase in the future. Each of these 9 options has
anywhere from 1 to 7 possibilities.

Any help would be appreciated. thx,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to dynamically change the list in drop down list based on thevalue of another cell? 1
Pick from drop-down list gives empty or erroneous result 6
changing validation drop down based on another cell value 5
Data Validation List (conditional) 2
Help with creating drop down 1
Data validation drop down list selection change 4
Drop-down list and error message 1
Choosing a drop-down menu selection returns value to another cell 2

Top