combining columns from to different files so that the rows match

  • Thread starter Thread starter lmikedes
  • Start date Start date
L

lmikedes

I have three files, all with a common column B labeled Serial Numbe
(numeric). The other two files have additonal columns, Program Clas
Code (text) in column C and Division (text) in Column D. Not all row
have data in them, as some are blank. I would like to combine al
three files, so that the information from the two files with th
Division Code and the Program Class code match the serial numbers. B
combining the row information from three different Excel files, I wil
create one file with all the information. The only criteria is tha
the serial numbers that identify each row, regardless of the fil
source, matches. Thanks
 
You want to do VLOOKUPS on column B.

To the right of the information in file1

=vlookup(B2,'C:\Documents and Settings\Administrator\My
Documents\[file2.xls]Sheet1'!$B:$B,2,"false")

Obviously your path and fileneme will be different. The 2
after $B:B$ is the column number for the information you
are pulling. i.e. b is 1, c is 2, d is 3 etc.

Do the same to the right of all this for file 3. Then copy
the whole sheet onto itself using paste-special> values.


Good Luck
 
Attached is a sample spreadheet. I want to combine the 2nd and 3r
files to the first, and assure that the serial numbers match. I know
need to add the two columns to the original table, but I am not sur
where to put the vlookup you mentioned. Can you asist? Thank

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=38043
 
Back
Top