How to check multiple entries on 2 different column

[hakim_tanzil]

Hi Guys

I need a formula to check multiple entries occur

Below is the table

A B C D
Date Name.1 Name.2 Check

25/04 Andy John "Error"
25/04 Chris Andy "OK"
25/04 John Andy "Error"


Any inputs would be greatly appreciated

 

[SanjayGMusafir]

But what if sometimes we only input 1 name

Adding to what @Joe4 said...

If we look at your sample data itself there can be multiple John or Andy. So there has be some additional factor to identify just in case you put in only one part of the name.