Quote Originally Posted by tsanodze
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)?
Hi,

With that example data in A1:D4, and the values 2 in F1, and 6 in G1, use the following formula:

=RIGHT(INDEX($A$1:$D$4,1,MATCH($G$1,OFFSET(A$1:D$1,MATCH($F$1,A$1:A$4,FALSE)-1,0),FALSE)),1)
HTH