Match and Index help with formula

[michelle 1]

Hi All
Am hoping someone can help me with this, my formula below isnt working and i cant work out why. I have entered it as an array.

Please Login or Register  to view this content.

I have attached my sheet i have changed the details but essentially where the name matches pass I want to return the value in column V.

Many thanks

[TheCman81]

Try this, entered as an array formula

=IFERROR(INDEX(Data!$V$2:$V$1000,MATCH(D2&F$1,Data!$Q$2:$Q$1000&Data!$U$2:$U$1000,0)),"")

[AlKey]

Or just regular formula

=IFERROR(INDEX(Data!$V$2:$V$1000,MATCH(D2,Data!$Q$2:$Q$1000,0),MATCH(F$1,Data!$U$2:$U$1000,0)),"")

[michelle 1]

Thankyou both for the formulas the sheet now works perfectly, really appreciate your help.

[ChemistB]

or if you just want to modify your original formula,

=(INDEX(Data!$V$1:$V$1000,MATCH(1,(Data!$Q$1:$Q$1000=D2)*(Data!$U$1:$U$1000=$F$1),0)))
arrayed.

[AlKey]

Thank you for the feedback!