When I try to fill series with the following: =INDIRECT("'"$A3$"'!C3") The
absolute ref advances by 1 step ( I want it to stay the same throughout) and
the C3 ref does not change at all. But it is the C3 ref that must change.
Thanks!
Ed

Ed,
try the following:

=INDIRECT("'" & $A$3 & "'!C" & ROW(C1))

This should look up cells like 'Sheet1'!Ci. The argument to ROW()
should be changed to a cell in the same number as the first cell you
want to reference in the target sheet.

Does this help?
Kostis Vezerides

Ed,

Try:

=INDIRECT("'"& $A$3 & "'!" & ADDRESS(ROW(C3),3))

HTH,
Bernie
MS Excel MVP


"milkman" wrote in message
...
When I try to fill series with the following: =INDIRECT("'"$A3$"'!C3") The
absolute ref advances by 1 step ( I want it to stay the same throughout) and
the C3 ref does not change at all. But it is the C3 ref that must change.
Thanks!
Ed

Sorry about the slow response. This did help Thank you!

"milkman" wrote:

When I try to fill series with the following: =INDIRECT("'"$A3$"'!C3") The
absolute ref advances by 1 step ( I want it to stay the same throughout) and
the C3 ref does not change at all. But it is the C3 ref that must change.
Thanks!
Ed

I tried the first answer I recieved and it worked. I will try yours later.
Thanks for the reply. Sorry about the late response.
Ed

"Bernie Deitrick" wrote:

Ed,

Try:

=INDIRECT("'"& $A$3 & "'!" & ADDRESS(ROW(C3),3))

HTH,
Bernie
MS Excel MVP


"milkman" wrote in message
...
When I try to fill series with the following: =INDIRECT("'"$A3$"'!C3") The
absolute ref advances by 1 step ( I want it to stay the same throughout) and
the C3 ref does not change at all. But it is the C3 ref that must change.
Thanks!
Ed