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.
Please see my answer to Sergei above, plus the picture I uploaded. I hope it helps, if not, tell me 😉
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.
- I appreciate the help and the tip SergeiBaklan
I am very new to this community and highly appreciate the comment 😉
As said to mathetes I need some pointers.
Also thanks everyone for the quick replies and help!- Thanks everyone for helping out! The issue has been solved and the weekends work has been completed 😄
Off topic: Why is this website so slow?