View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DS DS is offline
external usenet poster
 
Posts: 117
Default 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.)