I have 2 spreadsheets.
Columns are as follows:
Sheet1:
A M
Company Name | Phone Number
ABC 333 333 3333
DEF 444 444 4444
HIG 555 555 5555
HIJ 666 666 6666
Sheet2:
A J
Name | Phone Number
John 555 555 5555
Bob 333 333 3333
Tom 666 666 6666
For Phone numbers that exist in Spreadsheet 2, I want to add another column of Name that match the Phone number.
Basically I want to associate Names (john bob tom) to the relevant Company Name using the matching Phone numbers.
If it matters, each spreadsheet has 1000's of names and companies. Also some names and company name's may have NO phone number
How can this be done?
Bookmarks