I am trying to lock a cell reference in one sheet, so when data in another
page is moved the reference remains. I have tried the $ lock, but it still
moves.

formula :

=If(Sheet2:A5="JAN","",Sheet2:A5)

it is the first A5 which I do not want to be moved not matter what happens
to the cell.

This information will be held in Sheet one. So if I click and drag
information in Sheet 2 to a different cell, I want the formula to remain
readinf A5

Help please