Designing Survey Table Question

[stlpony]

[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Holiday[/TD]
[TD]First Course[/TD]
[TD]Second Course[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Christmas[/TD]
[TD]EggNog[/TD]
[TD]Cookies[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Christmas[/TD]
[TD]EggNog[/TD]
[TD]Milk[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Christmas[/TD]
[TD]Spaghetti[/TD]
[TD]Bread[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Christmas[/TD]
[TD]Spaghetti[/TD]
[TD]Salad[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Christmas[/TD]
[TD]Meatballs[/TD]
[TD]Sauce[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thanksgiving[/TD]
[TD]Turkey[/TD]
[TD]Corn[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thanksgiving[/TD]
[TD]Turkey[/TD]
[TD]Veggies[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thanksgiving[/TD]
[TD]MashedPotatoes[/TD]
[TD]Gravy[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thanksgiving[/TD]
[TD]MashedPotatoes[/TD]
[TD]Stuffing[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Which Holiday?[/TD]
[TD]First Course Options?[/TD]
[TD]Second Course Options?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Christmas[/TD]
[TD]EggNog[/TD]
[TD]Cookies[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]EggNog[/TD]
[TD]Milk[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Spaghetti[/TD]
[TD][TABLE="class: cms_table, width: 142"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 142"]=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))),"")[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Spaghetti[/TD]
[TD][TABLE="class: cms_table, width: 142"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 142"]=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))),"")[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Meatballs[/TD]
[TD][TABLE="class: cms_table, width: 142"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 142"]=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))),"")[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dropdown #1[/TD]
[TD]Dopdown #2[/TD]
[TD]Dopdown #3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]




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