Feb 22 2020 06:42 AM - edited Feb 23 2020 05:22 AM
Hi Community!
I am dealing with a problem. My company gave me 2 seniority lists: 1 old one with name/rank/base en the new 1 with only the ranks/base.
I am looking for a solution to merge the names into the new list.
I have been looking all over how to do this, but can't find the solution. Anyone here able to guide me?
Kind regards!
EDIT: picture uploaded
Feb 22 2020 07:11 AM
That's a bit abstract. If few people have the same ranks/base, bit more formal logic is to be added. If not, perhaps Power Query is the straightforward solution.
Feb 22 2020 08:36 AM
Sergei is right that your question is quite abstract--not enough in the way of specific details to give a truly helpful response. Is it possible for you to upload a sample of the two spreadsheets you have, after first rendering all names anonymous?
Feb 22 2020 12:00 PM
Feb 22 2020 12:03 PM
Feb 22 2020 12:17 PM
SolutionYou may XLOOKUP, VLOOKUP or INDEX/MATCH names based on ID:s if they are the same in both lists. From your sample it's not clear what is common between these two lists.
As a comment, it's better to submit sample file instead of the picture. Low chances someone will retype from your screenshot to the Excel sheet to play with formulas.
Feb 22 2020 12:26 PM
Feb 22 2020 12:52 PM
Both the efficiency of the look up and that of any manual checks can be made more efficient by sorting one or both lists by primary key.
Feb 22 2020 01:42 PM
Feb 23 2020 05:23 AM
Feb 22 2020 12:17 PM
SolutionYou may XLOOKUP, VLOOKUP or INDEX/MATCH names based on ID:s if they are the same in both lists. From your sample it's not clear what is common between these two lists.
As a comment, it's better to submit sample file instead of the picture. Low chances someone will retype from your screenshot to the Excel sheet to play with formulas.