Using the vlookup to sort through a sheet and only return products actually ordered

I have a large Item sheet that also functions as an order sheet so I want another sheet to return only items actually ordered. What is the correct vlookup formula for this situation?

in sheet #1, Column A has the number of orders needed (to be filled in), column B has the name of the product, column C has the price of the product. I want to look through column A after it is filled in and return the value of all three columns only if column A has a value larger than 0 into sheet #2 in the same workbook.

Thank you for any help!

Thank you, this is what I was looking for! Sorry to all for not posting a dummy workbook, I assumed it was such a simple problem that it wasn't needed.

I am having one issue with this, when I change the order back to zero on the ALL sheet the product name still appears on the ORDERED sheet with a zero in front of it, is there anyway of making it disappear when I change the order back to 0? By the way Alkey, your dummy workbook is exactly what I would have posted if anyone else has input, thanks for that.

Your sheet does work fine, I will start from scratch and figure out if I changed anything in the formula, thanks for getting back, I'll let you know how I do.

I found out what I did, I was adjusting the formula to fit with an extra row and I changed the Value if false part by accident, I changed it back and it worked, thank you for making me look!

This works like a dream and now I am trying to add more stuff into the equation, I want to add columns DEF from the ALL sheet (which are an extension of ABC) to add to the rows on the ORDERED sheet, can you give me some advice on how to add this to the formula?

I wanted to add 3 more columns of info from ALL into a single column on ORDERED, but on average each contributing ALL column was only a 1/4 of the original data, so I spilt the first column into 4 tables and it returns all the info (unless some freakishly large order was placed in one column). It works, I was just was wondering if I could do this without visible gaps between the tables in the ORDERED sheet or should I be approaching this in a different way? The more I learn, the more I realize I don't know...