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.