One way

Source table assumed in A1:D4

Inputs
in F1: 2 (value in 1st col),
in G1: 6 (value in 2nd row)

Then in H1:
=INDEX($A$1:$D$1,MATCH(G1,OFFSET($A$1:$D$1,MATCH(F 1,$A$1:$A$4,0)-1,),0))
will return the corresponding value in the 1st row (within A1:D1), ie: 3.
Copy H1 down to return as required for other input pairs in F2:G2, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"karl" wrote:
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