Formula Will Not Copy Correctly When I Pull The Formula Down the Worksheet

[ExcelHelpNeeded]

When I try to drag this formula down the column the formula does not populate correctly.

=IF(AB4="","",IF(COUNTIF(O$4:Y$4,AB4)=0,"L","W"))

What happens is the O$4;Y$4 stays the same all the way down. What I need it do to is to change to O$5;Y$5, O$6;Y$6, O$7;Y$7,etc.

I have never seen this before so I am kinda confused on what is going on here. Thanks for your help.

[AliGW]

So remove the anchors:

=IF(AB4="","",IF(COUNTIF(O4:Y4,AB4)=0,"L","W"))

[RET]

You are using fix reference to row by using $ jusf before row number so it will keep fixed.