Advanced formula filling Urgent

Hi!

I need to get this done for work and i can't seem to find how to do it.

In sheet 1:

c8: =IF(AND(C$3>='Sheet 2'!$N5;C$3<='Sheet 2'!$O5;'Sheet 2'!$N7=$C$1);1;0)
c9: =IF(AND(C$3>='Sheet 2'!$N10;C$3<='Sheet 2'!$O10;'Sheet 2'!$N12=$C$1);1;0)
c10: =IF(AND(C$3>='Sheet 2'!$N15;C$3<='Sheet 2'!$O15;'Sheet 2'!$N17=$C$1);1;0)

I want to be able to drag down this formula to c200 following this pattern creating

c11: =IF(AND(C$3>='Sheet 2'!$N20;C$3<='Sheet 2'!$O20;'Sheet 2'!$N22=$C$1);1;0)
c12: =IF(AND(C$3>='Sheet 2'!$N25;C$3<='Sheet 2'!$O25;'Sheet 2'!$N27=$C$1);1;0)

Is it possible to drag down a pattern like this?

Please help!

c12: =IF(AND(C$3>='Sheet 2'!$N20;C$3<='Sheet 2'!$O20;'Sheet 2'!$N27=$C$1);1;0) ???????

Hi,

Try this in C8 and copy down as required:

=IF(AND(C$3>=INDIRECT("Sheet2!$N"&ROWS($1:1)*5),C$3<=INDIRECT("Sheet2!$O"&ROWS($1:1)*5),INDIRECT("Sheet2!$N"&2+(ROWS($1:1)*5))=$C$1),1,0)

Regards

try
=IF(AND(C$3>=INDEX(Sheet2!$N:$N;ROWS($A$1:A1)*5);INDEX(Sheet2!$N:$N;ROWS($A$1:A1)*5+2)=$C$1);1;0)

oops missed a bit
try
=IF(AND(C$3>=INDEX('Sheet2'!$N:$N;ROWS($A$1:A1)*5);C$3<=INDEX('Sheet2'!$O:$O;ROWS($A$1:A1)*5);INDEX('Sheet2'!$N:$N;ROWS($A$1:A1)*5+2)=$C$1);1;0)'

INDEX is generally preferable to INDIRECT (more flexible and non-volatile) so I would recommend you go with Martin's formula, although both will work (I hope!)

Regards

E3: =IF(AND($GZ$5<=$B3;$B3<=$HA$5);'Sheet 2'!$E$12/$HB$5;0)

E4: =IF(AND($GZ$6<=$B3;$B3<=$HA$6);'Sheet 2'!$E$17/$HB$6;0)
thats not horizontally.