How to merge files?

**Larryq22** · 02-06-2009, 08:18 AM

Often I need to add data from one spreadsheet to the appropriate places on another spreadsheet. For example:

Sheet A has 10,000 records with these fields: id#, name, address, place of employment.

Sheet B has 5,000 records these fields: id#, GPA, college major, type of degree.

Some of the records in B contain information for the same id#'s as sheet A. I want to add this information together so that a Sheet C will have these fields: id#, name, address, place of employment, GPA, college major, type of degree.

What's the easiest way for Excel to do this?

**martindwilson** · 02-06-2009, 08:51 AM

copy sheet a to sheet c
then use a vlookup in columns e ,f,g of sheet c
assuming row one is the headers id/name ect then in e2
=VLOOKUP($A2,'Sheet b'!$A:$D,COLUMN()-3,FALSE)
drag across to col g
then down to end of data

**arthurbr** · 02-06-2009, 08:59 AM

Hi,
You can use the VLOOKUP function to add gpa, college and degree based on the id# something like =vlookup(id#,sheet2!your_range,2) for GPA, 3 for major and 4 for degree.

Don't hesitate to add a small sample if necessary

For information on how to use the forum please follow one of the links to our how to sections or frequently asked questions!
Navigation bar including the How to...? dropdown
How to videos
Frequently asked questions