VLOOKUP formula


B

Briggs

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)
 
Ad

Advertisements

S

Sheeloo

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

Briggs

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!
 
Ad

Advertisements

S

Sheeloo

Don't feel bad about not understanding... you will be an expert soon...

There are two parts...
One is getting the formula right... hope you got that.

Second is to convert the formula to values... this is optional. If you do
this then you are no longer dependent on the other sheet...

Suppose you have formulas in Col B and you want to convert them to the
values they represent...
Then select Col B, Copy and PASTE SPECIAL|Values on Col B itself.


Hope this makes sense...
 

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