Return non-blank cells based on drop-down

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

Thank you, JBeaucaire & Sixthsense.

JBeaucaire--the sheet works exactly like I was looking for (only showing the ingredients being used and not all of them), but I can't seem to make it work on my workbook. For the ingredient piece, I have the following code:

The "ingredient" equivalent for my actual work file is between cells C13:C22. The different "recipes" are in row 5 starting in column J. (They are a concatenation--does that make a difference?).

The code I am using is:

{=IFERROR(INDEX(INDIRECT("'" & $B$1 & "'!c13:c22"), SMALL(IF(OFFSET(INDIRECT("'" & Sheet1!$B$1 & "'!c13:c22"),,MATCH($B2, INDIRECT("'" & Sheet1!$B$1 & "'!5:5"),0)-1,,)<>"",ROW($B$3:$B$100)-2),ROWS($A$2:$A2))),"")}

I'm guessing it has something to do with the -1 and -2, but I've tried other numbers and still can't get it to work...

Any thoughts or anything that sticks out being incorrect?

Thank!

Jared

Thanks for your help. Find attached.