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.
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.