INDEX function multiple columns & rows

[jasebeds]

I am trying to put together a formula that will take the column value from
one cell and the row value from another cell and go to this table and enter
the number that corresponds with where the two values meet. Keep getting
#VALUE! error when I use the index function
5 10 15 20 25
6% 72 181 341 572 902
8% 75 198 393 699 1168
10% 78 216 455 859 1531

 

[Biff]

Hi!

One way:

A10 = 8%
A11 = 10

=VLOOKUP(A10,A2:F4,MATCH(A11,A1:F1,0),0)

Returns 198

Biff

 

[Toppers]

Using Biff's input cells:

=INDEX($B$2:$F$4,MATCH(A10,$A$2:$A$4,0),MATCH(A11,$B$1:$F$1,0))

OR

=SUMPRODUCT(($B$1:$F$1=A11)*($A$2:$A$4=A10)*($B$2:$F$4))