Index/Match Not Matching Correctly on Multiple Criteria Across Sheets

Hi all,

I'd like to exactly match the EAP code (A10), Login Department (A7) and Patient Name (B3) on the '2N' tab to a single row on the 'Raw Data' tab that contains the same criteria and after matching, return the corresponding column header on '2N' (Charge Date, Fee Schedule, etc.)

My first thought was to use Index/Match and try to concatenate the columns

=INDEX('Raw Data'!D:D,MATCH($B$3&$A10&$B$7,'Raw Data'!A:A&'Raw Data'!B:B&'Raw Data'!J:J,0))

However, it doesn't seem like A10 is searching over B:B, B3 isn't searching over A:A and B7 isn't searching over J:J.

eval image.jpg

How do I get these to correspond correctly and return?

SCHC Unit Charge Test 2N to Clin Nutr.xlsx

Brilliant! Thank you!!!