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
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