Vlook names

Hello all! I am in need of a simple "formula" that I could use on a daily to see which names are not on my spreadsheet. The names in column A/B will always be the same, but columns D/E will be the ones that constantly change.

Attached is my spreadsheet. If you could also explain how you did it, I would greatly appreciate it.