Match up data with 2 very similar data lists

June 20, 2011 at 14:58:02
Specs: Windows XP

I have two spreadsheets of data, which both contain two columns of data. The fist column is a company's name and the second is a person's name that corresponds to that company. Spreadsheet 1 contains the up-to-date list of company names, but I need to add the people's names which correspond to those companies from spreadsheet 2.

Spreadsheet 2 consists of an out-dated list of company names, which includes companies that were deleted and is also missing some companies that were added.

I am trying to find a way to add the people's names in spreadsheet 2 to the column of peoples names in spreadsheet 1, that have the same company name affiliated with them.


If abbot were the company in both spreadsheets and spreadsheet 2 has the name John in the people's names column, I need John to be put in the first spreadsheet in the column next to abbot.

If motorola was the company name in spreadsheet 2 but is not in spreadsheet 1, I don't need anything added.

I apologize if this was a bit confusing, and would greatly appreciate any help or advice from anyone!

Thank you,


See More: Match up data with 2 very similar data lists

June 28, 2011 at 21:37:22
Hi Bruce,

you can use index and match as sample below
sheet name
spreadsheet 1 - sheet1 ( complete list of company )
spreadsheet 2 - sheet4 ( company name and person ) - col B to C

type this in spreadsheet 1 next to company name


sheet4 -col B info (company name) must be the same with sheet1(G2)

try it

Report •
Related Solutions

Ask Question