EXCEL - Vlookup

Can someone show me how to do a simple EXCEL Vlookup.  I have two files and each file contains a column called Product_ID.  I want to return some columns from both files to form a new file.

File 1 -
ProductID     ProductDescription
12345555     Widget

File 2 -
ProductID     ProductCost
12345555     3.99

File 3 - Merge of files 1 and 2
ProductID     ProductDescription   ProductCost
12345555     Widget                          3.99
tmajor99Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

nutschCommented:
Try something like this and it should work just fine.

=vlookup(ProductID,File2!Range,2,0)

e.g.
=vlookup(a2,File2!$A$1:$B$200,2,0)

Thomas

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ProfessorJimJamMicrosoft Excel ExpertCommented:
create a folder named EE and download all the three attached files  saving them there.  then open file1 and then file2 and then file3.

enable data connection and then you would see how the formula works.
File1.xlsx
File2.xlsx
File3.xlsx
psteffCommented:
If you have all the same product ID’s in both files, then one of the shorter and easier ways to do this would be the following.

1.      Copy File 1 and name it File 3.
2.      From File 2, copy the data from the worksheet that contains the ProductID and ProductCost into a blank worksheet in File 3.  You can name that new worksheet in File 3 anything you want, but for the sake of this example, I will name it “File2Info”.
3.      The following assumes that all headings are in row 1.  All the data columns are in columns A and B.  For the sake of the formula, I will assume that the data does not extend beyond row 500.  Anything different from these assumptions, you will need to alter the formula accordingly.
4.      On the worksheet in File 3 that contains the ProductID and the ProductDescription, in cell C1, type in your heading “ProductCost”.  In cell C2 type the following formula

=VLOOKUP(A2,File2Info!$A$2:$B$500,2,FALSE)

5.      Copy this formula down to row 500 (or whatever is your last row of data).

6.      Once everything looks good, you can copy the new column C onto itself as “values only.”
7.      Then you can delete the worksheet called “File2Info”.
8.      File 3 should now be the way you want it and ready to go.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.