Match up data with 2 very similar data lists

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

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.

Example:

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,

Bruce


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

Report •


#1
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

=INDEX(Sheet4!$B$3:$C$12,MATCH(Sheet1!G2,Sheet4!$B$3:$B$12,0),2)

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

try it


Report •
Related Solutions


Ask Question