This is a very simple description of what I want to do
Cell A1 contains the value 99
cell A2 contains the value A
cell A3 contains the value 1
If I now type =A1 in another cell I get the answer 99. All OK so far.
What I want to do is to generate the command =A1 by assembling it from the contents of A2 and A3 and have it return 99. I have tried the commands, =concatenate(a2,a3) and =(a2&a3), and both put A1 in the cell and do not execute it. Is this possible.
Cell A1 contains the value 99
cell A2 contains the value A
cell A3 contains the value 1
If I now type =A1 in another cell I get the answer 99. All OK so far.
What I want to do is to generate the command =A1 by assembling it from the contents of A2 and A3 and have it return 99. I have tried the commands, =concatenate(a2,a3) and =(a2&a3), and both put A1 in the cell and do not execute it. Is this possible.