force evaluation of text
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)
"Light" wrote:
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!
|