Looking to Compare 2 Columns against another two columns to show duplicates / Differences

Hi People,

I am new to this Forum so firstly thank you in advance for anyone who reads this and provides any assistance or feed back.

At work I have a list of staff members from 2016 and a more recent list of staff members for 2019.

These lists are extremely large so i was looking for a formula which i can use to compare the two.

I am more than happy to copy the 2016 list and 2019 lists into the same sheet however I am struggling to get a formula together which will compare two columns against another 2 columns.

There are some entries with the same name so its important that i incorporate there telephone number which is in the next column along from their name.

I have uploaded an example which may help anyone who is kind enough to assist me.

Thanks you in advance.

Hello WildeBoyDixon,

Thank you so much for your advice.

I have tried entering that formula into the column you advised however it comes back saying that every member is new however some aren't new in comparison to the existing list.

Thanks once again.

Zeus82

HI WBD,

It will be something That I am doing wrong however please see attached.

Kind regards,

Zeua82

How about
=IF(IFERROR(MATCH($K10&"|"&$L10,INDEX($E$10:$E$18&"|"&$F$10:$F$18,0),0)*0,1),"New","Old")

HI WBD,

Thanks a million for your help, that last formula i managed to get working however yes I see my mistake in the previous.

I was transferring the formula over to the actual employee sheet which has many more details which is clearly when I have added the typos.

Thanks a million.

All I need now is a formula to reverse a date as the dates are written as 20180122 rather than 22012018 or even better still 22/01/2018. I will create a new thread and marked this one as solved.

Thanks a million for your assistance.

Kindest of regards,

Zeus82

Wow haha Perfect!

I really hope I can help you sometime!

Thanks again!

Zeus82