Forum Discussion
2 Seniority Lists: SOLVED
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
You 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.
9 Replies
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.
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.
- thank you for your reply. I have added a picture. There is about 10 bases for 1000 people, and by rank I meant seniority, so from 1-1000. Does this help?
