Return non-blank cells based on drop-down--Excel 2010

[j_harrison]

High-level, I'm trying to bring in non-blank cells for a given product selected from a drop-down menu.

I have multiple "category tabs"--cakes, cookies and main dishes. I have created 2 drop-down menus: 1 for the tab name and one for the recipes within each tab.

Each tab is set-up similar to the following:

	Chocolate	Carrot
Flour	1 3/4 Cups	2 Cups
White Sugar	2 Cups	1 1/2 Cups
Cocoa Powder	3/4 Cups
Baking Soda	2 tsp	2 tsp
Baking Powder	1 tsp
Salt	1 tsp	1/4 tsp
Buttermilk	1 Cup	3/4 Cup
Vegetable Oil	1/2 Cup	3/4 Cup
Eggs	2	3
Vanilla	1 tsp	2 tsp
Cinnamon		2 tsp
Shredded carrots		2 Cups
Coconut		1 Cup flaked
Walnuts		1 Cup Chopped
Pineapple (crushed)		8 oz
Raisins		1 Cup

<tbody>
</tbody>

What I'm hoping to do (without using VBA if possible) is bring in the ingredients in one column and the quantity in the other but only for the non-blank cells. So if cakes and carrot were selected, the output would look like this:

Flour	2 Cups
White Sugar	1 1/2 Cups
Baking Soda	2 tsp
Salt	1/4 tsp
Buttermilk	3/4 Cup
Vegetable Oil	3/4 Cup
Eggs	3
Vanilla	2 tsp
Cinnamon	2 tsp
Shredded carrots	2 Cups
Coconut	1 Cup flaked
Walnuts	1 Cup Chopped
Pineapple (crushed)	8 oz
Raisins	1 Cup

<tbody>
</tbody>

Sorry if I've given too much detail--this is my first post to mrexcel.com.

Thanks in advance for your help. I really appreciate it.

Jared