Howdy!
I am having some problems with my dependent drop down menus through Data Validation.
My spreadsheet has Type (Fruit, Vegetable), Color, and Food.
Both of these are valid combinations:
Veg--> Green --> Celery
Fruit--> Green --> Pear
However, regular dependent drop downs mean the food is reliant only on the color.
I have researched and figured out how to force the user to choose only valid 3-way links by using the OFFSET and MATCH functionality and by looking in the set list sorted by type & color. However, what has happened is that when the user chooses color, the exact same color will be repeated for however many instances of food there are. So, Red will be repeated for Apple, Strawberry, etc.
I can attach or send the spreadsheet if anyone can help.
Jake
I am having some problems with my dependent drop down menus through Data Validation.
My spreadsheet has Type (Fruit, Vegetable), Color, and Food.
Both of these are valid combinations:
Veg--> Green --> Celery
Fruit--> Green --> Pear
However, regular dependent drop downs mean the food is reliant only on the color.
I have researched and figured out how to force the user to choose only valid 3-way links by using the OFFSET and MATCH functionality and by looking in the set list sorted by type & color. However, what has happened is that when the user chooses color, the exact same color will be repeated for however many instances of food there are. So, Red will be repeated for Apple, Strawberry, etc.
I can attach or send the spreadsheet if anyone can help.
Jake