Excel: Search for and return values in a data range without an empty cell?

[pcguate]

Not sure how to properly explain this.

I have a table of food items only some of which will be ordered. In a separate tab I want to list out only those items that need to be ordered with the order quantity.

For example here is a data set:


[TABLE="width: 715"]
<colgroup><col><col><col><col><col span="3"><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD]Delivery Days:[/TD]
[TD="colspan: 4"] Monday[/TD]
[TD="colspan: 4"] Tuesday[/TD]
[/TR]
[TR]
[TD="colspan: 2"] [/TD]
[TD]Order (Friday)[/TD]
[TD]Sales[/TD]
[TD]Waste[/TD]
[TD]In
Stock[/TD]
[TD]Order[/TD]
[TD]Sales[/TD]
[TD]Waste[/TD]
[TD]In
Stock[/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Boursin Cheese[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Hummus Dip[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Hummus Trio Dip[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Mixed Berries and Fruits[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Blueberry Yogurt Parfait[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Mixed Fruits Parfait[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Strawberry Yogurt Parfait[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]The Californian Box [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]The Fresh Picnic Box[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]The Garden Box[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]The Italian Box[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]The Mediteranian Box[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]The Protein Box [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


So in a separate tab I want to only show what items need to be ordered on Monday and their quantity and then what items and quantities need to be ordered on Tuesday. I want to condense it down so you only see items that need to be ordered instead of all items.

I can't figure out a formula to do this. I assume I need some Vlookup formula, but how to do that to only search for non-empty order cells is alluding me.

I have the latest version of Excel for Windows.

Any help out be appreciated!