INDEX function multiple columns & rows
 

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

INDEX function multiple columns & rows
 

Hi!

One way:

A10 = 8%
A11 = 10

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

Returns 198

Biff

"jasebeds" wrote in message
...
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

INDEX function multiple columns & rows
 

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

"Biff" wrote:

Hi!

One way:

A10 = 8%
A11 = 10

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

Returns 198

Biff

"jasebeds" wrote in message
...
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