I have a problem fillling series with indirect function
 

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 have a problem fillling series with indirect function
 

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

I have a problem fillling series with indirect function
 

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

I have a problem fillling series with indirect function
 

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 have a problem fillling series with indirect function
 

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