I have a problem fillling series with indirect function

M

milkman

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
 
V

vezerid

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
 
B

Bernie Deitrick

Ed,

Try:

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

HTH,
Bernie
MS Excel MVP
 
M

milkman

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
 
Top