combining columns from to different files so that the rows match

[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

 

[drabbacs]

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

 

[lmikedes]

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