# Select Cell Value from table with multiple criteria

Occasional Visitor

# Select Cell Value from table with multiple criteria

I have a large data base, but with three criteria, I believe I can locate a single cell value and return the value of that final cell.  In the example below, I would want to find WC=61, Status=DT, and Hour=42, then return the value "Hydraulic".  This is a Downtime Database for which I want to return the note after satisfying the three criteria.  Here's a sample:

 DT Chart WC Status Hour Note 53 P 3 operator 53 DT 5 cups 53 DT 4 oil 53 DT 2 dirt 53 P 7 scratch 53 P 1 dent 53 P 9 ding 61 DT 20 Sensor 61 DT 14 Auto 61 DT 42 Hydraulic 61 DT 35 press 61 P 8 Hilo

Can you help me with a formula that will extract the word "Hydraulic" from this table of info?

1 Reply

# Re: Select Cell Value from table with multiple criteria

``=INDEX(D3:D14,MATCH(1,(A3:A14=61)*(B3:B14="DT")*(C3:C14=42),0))``

Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. An alternative could be VLOOKUP or - if you work with Office365 or 2021 - XLOOKUP. Of course you can make this formula dynamic e.g.

``=INDEX(D3:D14,MATCH(1,(A3:A14=A20)*(B3:B14=B20)*(C3:C14=C20),0))``

then you can enter the search criteria in cells A20, B20 and C20.