Variable within a formula
Gary, almost there... I was looking for ='040208'!A1+C4 and not just
'040208'!A1
I tried =INDIRECT(A1 & "!A1+C4") but it didn't work (A1 containing the
value '040208').
Thank you.
Eric
"Gary''s Student" wrote in message
...
Put 040208 in A1 and then:
=INDIRECT(A1 & "!C4")
will give you the same as putting:
='040208'!C4
in the same cell
--
Gary''s Student - gsnu2007g
"Eric" wrote:
Hello,
I would like to set a formala in a cell that would vary based on the
value
of an another cell.
The end result should look like: ='040208'!A1+C4 with 040208 being the
value
of the cell in question.
How can I do that?
Thank you.
Eric
|