Index/match formula - return #n/a error

**jBailey031285** · 03-13-2012, 05:47 PM

Please see the attached I think my formula in column I is incorrect - #N/A is returned for each cell. Cany anyone see if there is a error in my formula

**daddylonglegs** · 03-13-2012, 05:52 PM

Are you trying to return the column B value? Perhaps you want this version

=INDEX(PhysMaster!$B$2:$B$841,MATCH(G9&H9&F9, PhysMaster!$C$2:$C$841&PhysMaster!$D$2:$D$841&PhysMaster!$A$2:$A$841,0))

confirmed with CTRL+SHIFT+ENTER

....although I only get one match for you data, row 15

**JieJenn** · 03-13-2012, 05:53 PM

Should be Column A then D then C. You entered C, D, A

CTRL + SHIFT + ENTER

=INDEX(PhysMaster!$A$2:$A$841,MATCH(F9&H9&G9,PhysMaster!$A$2:$A$841&PhysMaster!$D$2:$D$841&PhysMaster!$C$2:$C$841,0))