force evaluation of text

L

Light

In cell A1 I have the value B and in cell A2 I have the value 6.

I want cell A3 to have the value of cell B6. I can get A3 to read B6 but no
to give me the value that is sitting in B6 (3512).

Is it possible to force the evalution of A3 (currently =A1&A2)
Thanks!
 
H

hmm

Check out the INDIRECT function; it is used for converting text to an actual
cell reference.

In the case you gave, you would type in cell A3: =INDIRECT(A1 & A2)
 
Top