2 Dimensional Lookup using nested v and h lookup

[lucaserino]

Hi,

I am trying to use two values one table as indexes for rows and columns in the other table so that I can get the value at the interesection of these coordinates.

This is the formula I'm using but it returns a #VALUE! error:

=INDEX(returns2,ROWS(VLOOKUP(A163,returns2,1,1)),COLUMN(HLOOKUP(B163,returns2,1,1)))

It would be much appreciated if someone could put me on the right track!

Many thanks,

Luca

 

[Jonmo1]

Try

=INDEX(returns2,MATCH(A163,INDEX(returns2,0,1)),MATCH(B163,INDEX(returns2,1,0)))