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:

	Delivery Days:	Monday	Tuesday
	Order (Friday)	Sales	Waste	In Stock	Order	Sales	Waste	In Stock
	Boursin Cheese	2			2	1			3
	Hummus Dip				0				0
	Hummus Trio Dip				0				0
	Mixed Berries and Fruits				0				0
	Blueberry Yogurt Parfait	3			3				3
	Mixed Fruits Parfait	5			5	4			9
	Strawberry Yogurt Parfait				0				0
	The Californian Box				0				0
	The Fresh Picnic Box	8			8	1			9
	The Garden Box				0				0
	The Italian Box				0				0
	The Mediteranian Box				0				0
	The Protein Box				0				0

<colgroup><col><col><col><col><col span="3"><col><col span="2"></colgroup><tbody>
</tbody>

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!