I'm sorry.

I copied and pasted and didn't notice the mistake in the original formula. I
was too busy concentrating on the lack of apostrophes!

The stuff after the exclamation point has to look like an address.

And I can't think of anything that you could put into A1 that would make A1+C1
look like an address.



Eric wrote:

Dave,

I tried all the solutions and everytime I changed the type of the cell A1
(to match the type expected) and I do have a sheet 040208.
I found something that worked. Instead of trying to incorporate the +C4
within the INDIRECT, I just took it outside...

=INDIRECT("'" & A1 & "'!A1)+C4 instead of =INDIRECT("'" & A1 & "'!A1+C4")

I wish I knew why the other one does not work because it does make sense...

Thank you.

Eric

"Dave Peterson" wrote in message
...
What formula did you use?

My real bet is that you don't have a worksheet by that name. Maybe
there's
something wrong with the value in the cell--or maybe there's something
different
with the worksheet tab.

I'd look for leading/trailing spaces in both spots to start.

Eric wrote:

Nope, thank you for trying. A1 was already formatted as text and it
still
does not work.

All your solutions return the same #REF! as mine.

Thank you.

Eric

"Dave Peterson" wrote in message
...
Maybe:
=INDIRECT("'" & A1 & "'!A1+C4")
or
=INDIRECT("'" & text(A1,"000000") & "'!A1+C4")
or
=INDIRECT("'" & text(A1,"mmddyy") & "'!A1+C4")

The apostrophes are required for lots of worksheet names.

And depending on what's in A1 (a number formatted to show leading 0's)
or
a date
formatted nicely), you may need to do that in your formula, too.

Eric wrote:

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




--

Dave Peterson

--

Dave Peterson

--

Dave Peterson