Hello,
I'm trying to lookup values in a list on a worksheet, based on multiple criteria from another worksheet. The list has several items, with each item using a division category and a building id number used for identification. See below:
Worksheet 1:
Criteria 1= cell A1= number (ex: 101101)
Criteria 2= cell A2= number (ex: 2)
Worksheet2:
1 A B C D
2 Description Qty Division Bldg
3 Signage 2 101101 1
4 Extinguisher 8 101400 2
5 Concrete 4 101400 2
Here's what I'm trying to do: If worksheet1 has a division number (ex: 101400) as criteria 1, and a building i.d. number for criteria 2 (ex: 2), how do I use these criteria to reference all the items in the list on worksheet2? Based on this example, I should get a list on worksheet1 that returns "Extinguisher" and "Concrete". I tried using a LOOKUP function, but I don't think it's possible because I'm using multiple criteria. I next tried using the functions INDEX and MATCH, but I'm not having any success. Anybody got any ideas? Thanks.
Bookmarks