Locking different values within cell depending if they are dragged vertically or horizonta

Hello all

I'm having difficulties figuring out a solution on how I can lock certain references within my formula depending upon whether I drag it along the row or down the column.

As I drag the formula along the row I require this;
=IF(FZ3=Import,VLOOKUP($A$8,'Edited Data'!$O$3:$P$3600,2,0),FZ3)

But if I am to drag the formula down the column then I need this;
=IF($F$Z3=Import,VLOOKUP(A8,'Edited Data'!$O$3:$P$3600,2,0),FZ3)

The key differences of those two formulas being the IF function reference cell (FZ3) and the VLOOKUP reference cell (A8).


Thanks!

Martin