Need Help with Vlookup

Hi all

I need some advice
I run a food business and use excel to run almost everything - soon to be everything.

My challenge today is shopping lists:
I am looking to create a summarized shopping list, at the moment I have a master sheet for our suppliers and have to
print/ look at the whole thing when it comes to shopping when some items are "0" needed for the week in question.

I think I need to use vlookup to summarize a list from the data to only show items that have a "1" or more in the quantity needed for that week. Please see workbook attached.

Really I need the summary to include severeal colums of info on each item, the brand, pack size etc

All tips on how to ask this question in future are welcome as are thoughts on the question itself.

Many thanks
Alex
The Spicy Chef

So, the tricky part is generating the dynamic list of just items that have a quantity >0.
Put this in cell K6, but enter it as an array formula (i.e. hit Ctrl-Shift-Enter)

Please Login or Register  to view this content.

Now drag it down to as many rows as needed.
Then you can use VLOOKUP to find the data for the other columns.

Cool. I'm in the middle of cooking spicy food myself right now but if you can give me half hour I'll take a look at providing a solution.

Unless of course Pauleyb's suggestion has already sorted things for you....

BSB.