Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.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). Your help is immensely appreciated. karl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row, Index, Match functions | Excel Discussion (Misc queries) | |||
INDEX & MATCH functions | Excel Worksheet Functions | |||
Problems with using match and index functions | Excel Discussion (Misc queries) | |||
Index and Match Functions | Excel Worksheet Functions | |||
How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions |