I have 2 system-generated reports that look like this:

A B C D

1 User ID Name Email Role
2 abc Jane Approving Officer
3 abc Jane Procurement Officer
4 abc Jane Receiving Officer
5 def Tim Receiving Officer
6 def Tim Procurement Officer
..... etc

Each person can have more than 1 role.I want to cross-check against these 2
reports and identify those unmatched entries (i.e. entire row of data is
available in 1 file but not the other). How do I go about doing it? v-lookup
doesn't help as there's no unique ID. Can I use access to do it?