Hi

Im trying to copy a VLOOKUP formula for the table being searched in ... down
all the cells in a column and want to auto enter the "$" prefixes to preserve
absolute cell refereneces.

Example

How do I automatically enter

=VLOOKUP(C2,Sheet1!C$2:D$5,2,FALSE)

instead of what normally comes up - which is

=VLOOKUP(C2,Sheet1!C2:D5,2,FALSE)

Has anyone any idea idea how to do this?