Comparing a list of names to another list of hyperlinked names to highlight similar

Solution attached.

First I used a formula to rearrange what I assume will be last and first names separated by a comma to match your new list.

Then a formula to check for matches in the new list.

Then conditional formatting to highlight any marked as "No Match."

Let me know if you have any questions!