index match match

pallet48

New member
Joined
Jun 28, 2014
Messages
1
Reaction score
0
Points
0
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
 

Attachments

  • index.jpg
    index.jpg
    97.3 KB · Views: 16
  • TEO.xlsx
    10 KB · Views: 14

kvsrinivasamurthy

New member
Joined
Jun 10, 2014
Messages
8
Reaction score
0
Points
0
Excel Version(s)
2019
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))
 
Top