Forum Discussion
2 Seniority Lists: SOLVED
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.
Sergei is right that your question is quite abstract--not enough in the way of specific details to give a truly helpful response. Is it possible for you to upload a sample of the two spreadsheets you have, after first rendering all names anonymous?
- Please see my answer to Sergei above, plus the picture I uploaded. I hope it helps, if not, tell me 😉
- 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.
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!
