NG said an error occurred - so I'll post again

try

=INDIRECT(B1)+C1

where B1 contains "A1" (w/o the quotes)



" wrote:

I have data in cell a1, I need a formula like d1 = b1+c1
I want b1 to point to a1 by reference only.

I just want to be able to enter a1 into b1 to get the value.
I do not want =a1 in cell b1.