Copy part of VLOOKUP formula?
 

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.

Copy part of VLOOKUP formula?
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

Copy part of VLOOKUP formula?
 

=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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

Copy part of VLOOKUP formula?
 

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

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


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

Copy part of VLOOKUP formula?
 

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

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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