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