duplicating/moving cells containing functions

[Haydo]

If i copy a cell containing a function, say VLookup, and paste it to another cell, the column particulars of the entries change.

The same happens when i drag the same cell across to the next cell.

How can i copy or drag a cell containing a function, and have the details of the function not change?

I have tried Special Paste but that seems not to work.

Thanks

 

[Haydo]

i think i got it. Just press the F4 button to make it absolute