# Urgent!! Advanced formula filling

• [INDENT]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?

• Re: Urgent!! Advanced formula filling

then in C9 drag down:
=IF(AND(C\$3>=INDIRECT("Sheet2!\$N"&ROW(\$A\$5)*ROW(A2)),C\$3<=INDIRECT("Sheet2!\$o"&ROW(\$A\$5)*ROW(A2)),INDIRECT("Sheet2!\$N"&ROW(\$A\$7)+ROW(A1)*5)=\$C\$1),1,0)

• Re: Urgent!! Advanced formula filling

Please don't use words like "Urgent" in your thread titles.

Also, please post links to all your crossposts: Message to Crossposters

Where there is a will there are many ways. Finding one that works for you is the challenge!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!