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