Holiday | First Course | Second Course | ||
Christmas | EggNog | Cookies | ||
Christmas | EggNog | Milk | ||
Christmas | Spaghetti | Bread | ||
Christmas | Spaghetti | Salad | ||
Christmas | Meatballs | Sauce | ||
Thanksgiving | Turkey | Corn | ||
Thanksgiving | Turkey | Veggies | ||
Thanksgiving | MashedPotatoes | Gravy | ||
Thanksgiving | MashedPotatoes | Stuffing | ||
Which Holiday? | First Course Options? | Second Course Options? | ||
Christmas | EggNog | Cookies | ||
EggNog | Milk | |||
Spaghetti |
<tbody> </tbody> | |||
Spaghetti |
<tbody> </tbody> | |||
Meatballs |
<tbody> </tbody> | |||
Dropdown #1 | Dopdown #2 | Dopdown #3 | ||
<tbody>
</tbody>
So, I'm trying to design a survey, by which DropDown #1 will show the holiday (either Christmas or Thanksgiving). If Christmas is selected, dropdown #2will have EggNog, Spaghetti, or Meatballs. Depending on what is picked in #2 , the third option will show what is left based on the database up top.
Questions:
1) How do I make a dropdown that only shows the unique values in cells B13:B17?
2) My formula in Column C is not working ... If Spaghetti is selected, I want the options to show Bread or Salad ... So how do I add this third question / layer to my formula?
Building off some great work/help from @Fluff in a different thread