Forum Discussion

Copper Contributor

Feb 22, 2020

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

excel

office 365

SergeiBaklan
Feb 22, 2020
Aminam20

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.

Aminam20

Copper Contributor

Feb 22, 2020

Please see my answer to Sergei above, plus the picture I uploaded. I hope it helps, if not, tell me 😉

mathetes

Gold Contributor

Feb 22, 2020

Let us know if you need help with those functions that Sergei mentioned. That would be the way to do it, and easy if you know how.