Use a named range instead of cell references

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Marianne" wrote in message
...
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?