drop down boxes

[SharonMee]

Hi all:

Please help with the following:

I want to create a drop down list in a cell. The values in this drop down also have separate values of their own which will be placed in a different drop down list.

E.g.

first drop down list:

Breakfast
Lunch
Dinner

second drop down list- if Appetizer is selected, I want the following to be in the second drop down list:

hash browns
eggs
bacon

second drop down list- if Lunch is selected, I want the following to be in the second drop down list:

rice
chow mein
chicken

I know how to create the first drop down. what I did was to list "breakfast", "lunch", "dinner" in separate cells in a different worksheet and then I named the range and then data-validation-settings-allow-list

how do I link the second drop down list to achieve this?

Thanks so much for helping in advance

SharonMee

 

[000Steve000]

You could place a formula in 3 target cells the contents of which become the data source for your next list: eg


=IF(A1="Breakfast","Hash Browns",IF(A1="Lunch","Rice","dinner1"))
=IF(A1="Breakfast","Eggs",IF(A1="Lunch","Chow Mein","dinner2"))
=IF(A1="Breakfast","Bacon",IF(A1="Lunch","Chicken","dinner3"))

Where A1 contains your Breakfast/Lunch/Dinner list.