Copy part of VLOOKUP formula?

[absfl]

Thanks in advance..
I have 2 sheets and am using the following formula to try and match up names
in the 2 sheets. The formula I am using is =VLOOKUP(A2,
Sheet2!A1:A2087,1,FALSE)
to search for a match and indicate so in a 2nd column.
Since I have 2087 lines of data I tried to copy this formula for each cell
using the fill handle, but this always starts my reference at the next cell
(ex: A2:A2088 and so on). How can I change the A2 portion of my formula
without changing the reference of A1:A2087 without writing each cell's
formula by hand? I was hoping this formula would be a timesaver, but so far
it doesn't seem so.

 

[Don Guillett]

If you insist on doing it this way.
Sheet2!$A$1:$A$2087,1,FALSE

 

[Niek Otten]

=VLOOKUP(A2, Sheet2!A$1:A$2087,1,FALSE)
or
=VLOOKUP(A2, Sheet2!$A$1:$A$2087,1,FALSE)

Use the F4 key to toggle between absolute and relative references

 

[Alan]

=VLOOKUP(A2, Sheet2!$A$1:$A$2087,1,FALSE)

Have a look at 'Absolute Reference' in Help.
Regards,
Alan.

 

[absfl]

I am relatively naive on using Excel for this sort of thing. Is there a
better way?
A