Forum Discussion
Solved
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 n...
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.
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?
