Formula fill series?

[Laly1]

Hi there, im wondering if it is possible to fill a series of formul
down a Column so the sheet it is referencing is in series but the cel
reference stayes the same.

i.e. in cell A1, formula reads =Sheet1!$C$3,
then in cell A2, =Sheet2!$C$3,
cell A3 =Sheet3!$C$3 etc.

another example;
In cell A1, =IF($B3=0,"",IF(Sheet1!$A$20="","",Sheet1!$A$20))
cell A2, =IF($B3=0,"",IF(Sheet2!$A$20="","",Sheet2!$A$20))
cell A2, =IF($B3=0,"",IF(Sheet3!$A$20="","",Sheet3!$A$20))

Thanks

 

[Claus Busch]

Hi Laly,

Am Fri, 19 Apr 2013 03:51:44 +0100 schrieb Laly1:

i.e. in cell A1, formula reads =Sheet1!$C$3,
then in cell A2, =Sheet2!$C$3,
cell A3 =Sheet3!$C$3 etc.

in A1 try:
=INDIRECT("'Sheet"&ROW(A1)&"'!$C$3")
and copy down


Regards
Claus Busch