activate a list in one cell from a text "trigger" in a different cell

[d5hole]

i am trying to do the following -

cell A1, is a drop down list of the headers of 3 separate lists

in cell a2 - i need a formula that would activate a drop down list based on the selected text in cell A1 -

example

list 1 - BREADS list 2 - CHEESES list 3 - CONDIMENTS
wheat swiss ketchup
white american mustard
rye cheddar pickles


A1 drop down list -
Breads
Cheeses
Condiments

A2 - if i chose "Cheeses" in A1 - this cell would activate list 2 and allow to choose from swiss,american,cheddar

any help would be greatly appreciated !!!

 

[rallcorn]

Welcome to the board!

Create 3 Named Ranges (Spelled exactly the same as your 3 choices in A1 dropdown)

The A2 data validation use "List" and in "Source" input =INDIRECT(A1)

 

[d5hole]

PERFECT !!!!!!

done - and working - !!

thanks very much Rallcorn !!!

 

[rallcorn]

Happy to help!