Build a formula from contents of other cells?

  • Thread starter Thread starter Dan Reynolds
  • Start date Start date
D

Dan Reynolds

Greetings

I don't think it is possible to do the following:

cell A1 contains: =Sheet2!
cell A2 contains: G
cell A3 contains: 3

cell A4 contains: +A1+A2+A3

to produce the formula '=Sheet2!G3'

But is there another way to achieve this so that I can
regularly change many formulas by changing the contents of
one cell?

thanks
Dan
 
Dan

Put sheet2! in A1, G in A2 and 3 in A3 and in A4 the
formula
=INDIRECT(A1&A2&A3)

Tony
 
Back
Top