Read text as a cell for a formula

  • Thread starter Thread starter natepaul
  • Start date Start date
N

natepaul

I have two formulas in two cells, one spitting out a value for a colum
(A) and the other a value for a row (2). In the a third cell I'm addin
the letter and number together to create a cell address (A2). I want t
use this information in a fourth cell for a formula (=A2*$B$10).

But, how do I get Excel to recognize the text "A2" as a value for
cell and then add A2 (or whatever the third cell may be) in to
formula?

Any help?

Thanks,
Nat
 
Hi Nate
try
=INDIRECT(A4)*$B$10
where A4 stores your cell reference as text, e.g. 'A2'
(combined/created by other formulas)

HTH
Frank
 
Back
Top