If your sample table is *real* then all you need to do is divide:

give me 3...by typing 2...and 6

=6/2


--
Biff
Microsoft Excel MVP


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