Hi,
Why don't you just make a unique value in another colum. Take the first to
letters of the name and three first letters of the role name. Or convert the
different roles into numbers.
Then, you can easily check two arrays via look ups or index match.

A B D E
F

1 User ID Role
2 abc Approving Officer 1
ABC1
3 abc Procurement Officer 2
ABC2
4 abc Receiving Officer 3
ABC3
5 def Receiving Officer 3
DEF3
6 def Procurement Officer 2
DEF2


"ft1986" wrote:

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?