Forum Discussion
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, an...
=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.