I have two excel files:

file 1:
Column 1 has ID
Column 2 has name
Column 3 has status

file 2:
Column 1 has ID
Column 2 has Type

The ID in both files are the same, I want to merge the files, so the names corresponding to the IDs appear in column 3 of the second file.

I think this can be done with vlookup; however, I'm not sure what formula to use.

Any suggestions?

 

Can't you just data sort by ID on both then just copy the column needed into the other file?




(I'm assuming the ID data is the same.)

 

Use Vlookup. Let me see if I can work out a formula.

brb

 

Edit by Jonesi: Look two posts down for updated info..



In the 1st file, make column D "Type"

Then:

=VLOOKUP(A2,[File2.xls]Sheet1!$A$2:$B$10,2,FALSE)

And drag that down Column D

 

in file 2, column 3, type =vlookup(=<column A row 1 value>,<full range file 1 columns 1-3 all rows, 1, )

this'll return ID. if you put 2 at the end, it'll return name. likewise, 3=status. use '$' on the range values, then copy down column 3 in file 2.

Tough to describe, hope it makes sense.


Edit: don't use carrots to put things in parens, and look like a rookie compared to the previous post

 

Sorry did the ass backwards from what you wanted.

Try this:
=VLOOKUP(A2,[File1.xls]Sheet1!$A$2:$B$10,2,FALSE)



I think this is what you asked for.

 

Use the insert function feature for vlookup, it will bring up a dialog box for you to enter the parameters, that way you don't have to just type it in.