Hi Guys

I have a list of names on Sheet 1 E.g Joe Bloggs; Nancy Smith

On sheet 2 i also have a list of names E.g Bloggs, Joe F; Smith, Nancy A.

I would like to see if there is a way to lookup the names on sheet 1 (Surname most probably) to see if they exist anywhere in Sheet 2.

Is there an easy way of doing this without text to columns?

Thanks

5h1l