Hi,
I have an IF function comparing 2 cells and it is under column C:

A B C
cat Dog "=if(A1=B1,1,0)" (here result is 0)
Dog bird "=if(A2=B2,1,0)" (here result is 0)

Now, every time the result is ZERO in column C, I will move the
corresponding data on column B downwards "Insert - Shift cells down". The
problem here is that my formula on column C also moves downwards! So if I
moved down the data on B1 (Dog), the formula on C1 becomes "=if(A1=B2,1,0)".
Is there a way that the formula will still compare the original 2 cells even
if I moved the data down?? That is, the formula on C1 will still be
"=if(A1=B1,1,0)"


Thanks.