Howdy,

I am trying to drag and copy a formula to alot of cells, The formula is:

='Master Index'!$AB4

I am trying to use an absolute value for column AB and not row 4; however, when I drag and apply the formula to all the other cells it is as if the formula was $AB$4.

What do I need to do to lock the formula to just the AB column.