How to return the values from a list while ignoring blanks?

[stlpony]

Hello!

Have a question ... Here is my table

Christmas	EggNog
Christmas	Spaghetti
Christmas	Meatballs
Thanksgiving	Turkey
Thanksgiving	MashedPotatoes
Holiday?	Options?
Thanksgiving	=IFERROR(INDEX($A$1:$B$5,MATCH(ROW()-ROW($A$8),$A$1:$A$5,0)),"") <tbody> </tbody>

<tbody>
</tbody>

I'm trying to make a simple survey ... If cell A8=Thanksgiving, I would like "Turkey" listed in cell B8, and Mashed Potatoes listed in B9. Thought I had the formula correct, but appears not ... Any idea??

 

[Fluff]

Try

Excel 2013/2016
	A	B
1	Christmas	EggNog
2	Christmas	Spaghetti
3	Christmas	Meatballs
4	Thanksgiving	Turkey
5	Thanksgiving	MashedPotatoes
6
7	Holiday?	Options?
8	Thanksgiving	Turkey
9		MashedPotatoes
Offer Received

Cell Formulas
Range	Formula
B8	=IFERROR(INDEX($B$1:$B$5,AGGREGATE(15,6,(ROW($B$1:$B$5)-ROW($B$1)+1)/($A$1:$A$5=$A$8),ROWS($1:1))),"")

 

[stlpony]

This is great! Now expanding this a little ... (I'm actually trying to create a dinner survey)...

 

[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 #2 will 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?

Thanks!

 

[Fluff]

This is now a completely different question, so you will need to start a new thread.