Whatsthe formula which retrieves a # from a multiplication table
Hi DS,
It looks as if a3 could contain the formula:
=a1*a2
Hope that helps ?
Anthony
"DS" wrote:
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.)
|