Hello.

I have a rather long formula which I require to FILL DOWN (see below).
I have used the $ signs to prevent excel from filling down certain numbers and letters, but I cannot get it to fill down the other number - in the example below I would like Excel to continue down from 848 by 1 step increments, but it only repeats the number 848

=IF(ISNUMBER('848'!$C$148),"OK",IF(Finance!$D$2>'848'!$A$148,"CHECK"," ")).

In other words, how can I get Excel to recognize that the number in the 848 position needs to go up by 1 down the column?

Thank you.