Hi Marianne,

In the formula, select Sheet1 and press F4 twice.
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"Marianne" wrote:

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?