View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karl Karl is offline
external usenet poster
 
Posts: 114
Default Reverse Index and Match Functions

Hi,
Via the INDEX and MATCH functions I can get the intersection of a column and
raw cells in the multiplication table. Is there a reverse formula that shows
a value from the first column, using two values, one from corresponding
intersection and the other from the first row of the multiplication table.

To ilustrate:

1 2 3 4
2 4 6 8
3 6 9 12
4 8 12 16

by typing 2 (from the first row) and 3 (from the first column), the INDEX
and MATCH functions give 6, an intersection of 2 and 3 from the table.
A desired formula should give me 3(from the first column), by typing 2 (from
the first row) and 6 (intersection).

Your help is immensely appreciated.

karl