Vlookup or index matching needed please help

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

Please post a sample file showing sample expected results: we can't work with images!

I made myself a spreadsheet to remember my formula for "multiple vlookup"

You can take a look at it, in yellow cells is where should the answer appear. To enter the formula, enter it in the first cell where you want the answer to appear, then press CTRL-SHIFT-ENTER. Copy it and paste it down to as many cells as you want.

Hope it helps, at least until someone brings a better answer maybe.

Dummy Inventory.xlsx

here is a Dummy sheet

I have named a sheet "Orders" in which you will the following formula to list the "Time to Order" parts.

=IFERROR(INDEX(Inventory!$B$3:$B$45,SMALL(IF(Inventory!$A$3:$A$45="Time to Order",ROW($A$3:$A$45)-ROW($A$3)+1,""),ROWS($A$3:A3))),"")

The formula must be entered with Ctrl+Shift+Enter (an array formula). If entered correctly you will see curly brackets appear { } round the formula.

When entered in the first cell, drag it down as far as required.

You can try this

Thank you both. I am going to check these out in the morning and see if I can understand what you did and how to tweek it to match my actually sheet! If I have questions I'll post them tomorrow. And if not then I'll mark solved and do the reputation thing!