drag and fill formula problem

[bklefos]

I am working on a summary sheet which in each cell a formula exists. This formula compares a cell on sheet 1 to sheet 2. If sheet 1 and sheet 2 do not exist it will read ERROR. This is what i want. However, when i try to drag my formula I cannot get excel to understand the pattern i would like it to drag.

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

 

[bklefos]

you rock! It all worked.

Thank you very much.

 

[bklefos]

you rock!

All works great.

Thank you very much for your time and patience with me. Have a wonderful weekend.

 

[RalphA]

Thank you, Brian, for your thanks and "great weekend" wishes. As you can see, once I had enough information from you to understand exactlay what you needed, I was able to do so. On your next post, help us guys out, by posting more than enough information, rather than too little.

And, may your weekend be great, also!

Ralph