With this placed inside the formula bar:
=VLOOKUP(C2,Sheet1!C2:D5,2,FALSE)
select only this range part: C2:D5
then hit F4 to toggle through the 4 different states (the $/no $ signs)
Stop the F4 toggle when the desired state appears: C$2:D$5

voila? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Marianne" wrote:
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?