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