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)?

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:

Please Login or Register  to view this content.

HTH

Thank you!!!

big help. thanks