| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Whatsthe formula which retrieves a # from a multiplication table
I have a table that is similar to a multiplication table.
I would like to write a formula in a single cell (example A3) that retrieves data from a table by matching values typed in cells A1 and A2 (Example1: A1 has the number 5 typed in and A2 has the number 10 typed in). A3 should result with a 50.) (Example2: A1 has the number 6 typed in and A2 has the number 3 typed in). A3 should result with a 18.) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| one formula to make a multiplication table work | Excel Worksheet Functions | |||
| Get Pivot Table Data Formula | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Threaded Mode
