You've been a huge help, but I'm really a novice at this and what I don't
understand is the actual mechanics. If my formula is in cell B1 in sheet 1,
what do I copy and paste special.....specifically, what rows/columns do I
select on what sheet? sorry to be so confused. I'm almost getting this, but
am stuck on what I copy and paste to where. Thanks for your help!
--
Briggs


"Sheeloo" wrote:

Your formula or
=VLOOKUP(A1,Sheet2!$A$1:$C$1000,2,FALSE)
since Col D is not really required will give you last names in Col B for
those IDs which are present in Sheet2 and #N/A for those which are not.
Similarly
=VLOOKUP(A1,Sheet2!$A$1:$C$1000,3,FALSE)
will give you the first names...

If you want to see which IDs are there in Sheet 2 and Not in Sheet1 you can
have the reverse formaul in Sheet2 Col D like
=VLOOKUP(A1,Sheet1!$A$1:$A$1000,1,FALSE)
#N/A will give you the Ids which are not in Sheet 1...

You can filter and copy those on to Sheet 1..

Once you are done you can convert your formulae to values by Copying and then
PASTE SPECIAL|Values..

Hope that is what you wanted...



"Briggs" wrote:

I have two spreadsheets that I need to merge and am using a VLOOKUP formula.
Sheet 1 has ID numbers in column A; Sheet 2 has ID numbers in column A, last
names in column B, and first names in column C. I need Sheet 2 to merge into
Sheet 1, putting the correct name with the corresponding ID number.

I have a VLOOKUP formula in cell B1 Sheet1. What's my next step? The
formula is =VLOOKUP(A1,Sheet2!$A$1:$D$1000,2,FALSE)
--
Briggs