Lookup values when one or more properties need to be matched.
=INDEX(Copy!T:T, MATCH(1,IF(Copy!B:B=Sheet1!B2, IF(Copy!H:H=Sheet1!H2, IF(Copy!S:S=Sheet1!S2,1))),0))
Copy!T:T – Row to get data from (usually will be from another sheet)
Copy!B:B=Sheet1!B2 – Search through first criteria
Copy!H:H=Sheet1!H2 – search through second criteria
Copy!S:S=Sheet1!S2 – search through third criteria
Please note that the references might change, depends on the file layout
If more or less requirements are required add or delete appropriately. Press CTRL+SHIFT+ENTER
