Here is my formula. Each sheet is labeled as Results ()

=IF('Results (1)'!H11='Results (5)'!H7,"","ERROR")

I also typed in the cell to the right correctly as

=IF('Results (2)'!H11='Results (5)'!H8,"","ERROR")

Those are in columns A & B

When i drag the formulas off to the right i get this in columns C & D

=IF('Results (1)'!J11='Results (5)'!J7,"","ERROR")

=IF('Results (2)'!J11='Results (5)'!J8,"","ERROR")

The proper calculations should be

=IF('Results (3)'!H11='Results (5)'!H9,"","ERROR") IN CELL C

=IF('Results (4)'!H11='Results (5)'!H10,"","ERROR") IN CELL D

How do i keep some of my calculation constant and some as if it is counting up? When i drag to fill it automatically repeats the calculations as if i want it 1,2,3,1,2,3 rather than 1,2,3,4,5,6

Any help would be great and would save me lots of time