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!