Copy part of VLOOKUP formula?

A

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.
 
N

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
 
A

Alan

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

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

absfl

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top