Return non-blank cells based on drop-down

[j_harrison]

I've spent way too much time trying to figure this out on my own and have now swallowed my pride...This is my first post to excelforum, so I apologize if I've done something incorrectly.

I've created a "dummy" spreadsheet to mimic what I'm trying to accomplish.

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

Cell B3: would like to be able to have a dropdown menu (cells B2:possibly up to KO2) based on the "Category" selected in B2. (If this is not possible, I can have a separate "Ingredients Output" tab for each type of "Category"--it's just not optimal)

And then in cells A7:B??, show the ingredients and quantity needed for the selected "Recipe" in B3.

I'm really hoping to not have to use a macro.

Using Excel 2010

Thanks in advance for your help! I'm extremely grateful for people like you who are far smarter than I ever hope to become!

Jared