index match match

[pallet48]

Hello,

have been practising a two way lookup but keeping getting a error message, have retraced my steps but to no avail

had read it might be a ctrl shift enter problem , but havent much knowledge of array formulas


any help much appreciated

stu

[kvsrinivasamurthy]

Change formula
=INDEX(B11:F19,MATCH(B3,B11:B19,0)*MATCH(C3,B11:F11,0))
as
=INDEX(B11:F19,MATCH(B3,B11:B19,0),MATCH(C3,B11:F11,0))