problem with copying formula to other cells

Hi

I am trying to make a formula which has to look to different cells.
So the first cell contains the following formula:

=IF('all branches '!$G2=1,'all branches '!$P2,IF('all branches '!$G3=1,'all branches '!$P3,0))

and the next cell below it should be

=IF('all branches '!$G6=1,'all branches '!$P6,IF('all branches '!$G7=1,'all branches '!$P7,0))

If I however use the drag fuction excel makes it

=IF('all branches '!$G3=1,'all branches '!$P3,IF('all branches '!$G4=1,'all branches '!$P4,0))

The problem is that will the outcome of the formula has to go cell by cell, but the information used by the IF function has to make steps of 4 cells per time. How can I solve this problem. Addaping the cell numbers in the formulas is not really an options since I will have to cpy this formula around 500 times.

I hope it is clear what I mean. English is not my first language.
Thanks in advance
David Jansen

Will all the formulas need to increase by 4?