Comparing a list with names that not match

Hello,

I need to compare data from 2 sheets (highlighted in blue) with the following challenges:

1. List 1 contains who got access to the room and list 2 who has paid.
2. Who is on one list and not on the other one and vice-versa?
3. The names come in different formats. That should be relatively easy with the Text to Column function, although many names do not follow the standard 'name-surname' format. ie. Ursula von der Leyen, middle names, etc.
4. List 2 contains an ID number linked to each employee.

Any help will be greatly appreciated.