Kevin Smith
asked on
Compare names to nameID on spreadsheets
I have two spreadsheets. Spreasheet A is a company list with companyID and companyname. Spreadsheet B is a list of activites with several fields including a field for companyname. How do I compare the two spreadsheets and change all the companyname's in Spreadsheet B to the corresponding companyID in Spreadsheet A?
Thanks!
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER