• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • 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?

Thanks!
0
Kevin Smith
Asked:
Kevin Smith
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Here is a sample workbook showing one way to use MATCH and INDEX to achieve your objective.
Name-and-IDs.xlsx
0
 
Kevin SmithAuthor Commented:
perfect, thanks!
0
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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