I have a cell (A1) in one of my spreadsheets which has the value B501. The format of the cell is TEXT. What I now want to do is create a formula in another cell (B1) which needs to refer to the real cell B501. However I cannot make a direct link to the real cell B501 --> I have to use the text in cell A1 to be able to make the link to cell B501 but I am not sure how to do this.

If I would put the formula =A1 in cell B1 I would of course get B501 returned, but what I actually want returned is that the value in cell B501 is returned.

Is this possible in excel??

Howdy. Use the INDIRECT function

=INDIRECT(A1)

thanks! this works perfectly