View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jasebeds jasebeds is offline
external usenet poster
 
Posts: 1
Default 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