HLookup/ Vlookup Multiple Criteria

[mdonovan890]

I have two tabs within my 2016 Excel workbook the first is called "Look up" and the second is "Return Value" . The formula I need would search the "Look up" Sheet and return "Test Preformed by" on the "Return Value" Sheet using the "Test ordered In" and "TEST #" as the criteria for the lookup. For example if on the "Return Value Sheet" in Column A I put in "Sacramento" and in Column B I put in "1002-IVS" the formula should return "NE". I have tried various index/match formulas and vlook/hlookup but have not had any luck.

 

[AlphaFrog]

Try this. Change the K to the last Location column

=INDEX(Lookup!D:K,MATCH(B2,Lookup!B:B,0),MATCH(A2,Lookup!$D$1:$K$1,0))