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
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))
Bookmarks