Reference a cell in another cell (non-standard way)

[rabindra666]

Hi,

I'd like to know if / how the following is possible:

I have say a figure, 45, in cell A1.

In cell B1 I have written simply A1 (not =A1, simply A1)

Now, in cell C1 I want to refer to cell B1, using the value inside B1 (which is A1), to refer to the CELL A1, and return a value of 45.

Obviously if in cell B1, I write =A1, then there is no problem, but without the "is equal to" sign, can this be done?

Any ideas?

Thanks.

Rabindra

[Norie]

Perhaps INDIRECT.

=INDIRECT(B1)