Select Cell Value from table with multiple criteria

[TGreen007]

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?

[#2]

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