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 !!!
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 !!!