Hello,

I am trying to set an inventory spreadsheet. So far I have been able to do everything I want (with the help of some people on here). But now I am struggling getting a vlookup to work. After doing some research I'm not sure if vlookup is the best option.

I have a column with a function that tells me when I need to order inventory. It's based on different criteria. Anyway - when I need to order it will pop up "Time to Order". I need to create a list of just the things that have that? I have another worksheet that I am creating that will allow me to enter all inventory purchase information that I can submit for approval before purchasing.

I was thinking that I would create a vlookup to search through column A and display the items from column B in any row that has "Time to Order". The problem is it is only bringing one row (row 45) and showing "Wheel". I need it to list rows 15, 26, 30 and 35. Any suggestions? The screenshot is a dummy sheet. Once I get a base formula for that sheet I can manipulate it for my actual worksheet.

2015-07-28 11_40_09-Microsoft Excel - Inventory Master.png