• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

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?

Kevin Smith
Kevin Smith
1 Solution
Saqib Husain, SyedEngineerCommented:
Here is a sample workbook showing one way to use MATCH and INDEX to achieve your objective.
Kevin SmithAuthor Commented:
perfect, thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now