Select Cell Value from table with multiple criteria

Occasional Visitor

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
WCStatusHourNote
53P3operator
53DT5cups
53DT4oil
53DT2dirt
53P7scratch
53P1dent
53P9ding
61DT20Sensor
61DT14Auto
61DT42Hydraulic
61DT35press
61P8Hilo

 

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

1 Reply

@TGreen007 

=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.