Designing Survey Table Question

[stlpony]

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	=IFERROR(INDEX($C$2:$C$10,AGGREGATE(15,6,(ROW($C$2:$C$10)-ROW($C$2)+1)/($B$2:$B$10=$B15),ROWS($2:4))),"") <tbody> </tbody>
	Spaghetti	=IFERROR(INDEX($C$2:$C$10,AGGREGATE(15,6,(ROW($C$2:$C$10)-ROW($C$2)+1)/($B$2:$B$10=$B15),ROWS($2:4))),"") <tbody> </tbody>
	Meatballs	=IFERROR(INDEX($C$2:$C$10,AGGREGATE(15,6,(ROW($C$2:$C$10)-ROW($C$2)+1)/($B$2:$B$10=$B15),ROWS($2:4))),"") <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

 

[MickG]

The Linked example here (if acceptable !!) may help !!!
https://www.mrexcel.com/forum/excel...drop-down-list-dictionary-keys-3-columns.html

 

[stlpony]

The Linked example here (if acceptable !!) may help !!!
https://www.mrexcel.com/forum/excel...drop-down-list-dictionary-keys-3-columns.html

Having a hard time clicking through to that link ...

 

[MickG]

Try this for basic Idea:-
https://app.box.com/s/22y95iyfb7rg0h3d0molm9r0yvwhtu8b