Indexing to Compare Against Two Columns

[suruat68]

I'm hoping someone can help me or point me in the right direction. I've searched all over off an on for years and can't find the solution. I've found similar problems to the one I want to solve, but nothing that works with my situation. You may be my last chance!

Here's what I would like to do. Frankly, I'm not sure if this is even possible.

I have two reports. One is a system generated report that provides User IDs and the Roles that the user has access to within that application. A user may have multiple roles.

The second report is from a database that is updated by the system administrator whenever they add or remove a user from the application. Neither the System List or the Database list will ever be 100% accurate so occasionally I have to compare the user lists from both reports and find and fix any discrepancies.

Right now I index reports and match the User ID then place the spreadsheets side-by-side and manually scan them to make sure the roles match the user ID, but that is extremely time consuming when I have 1000's of lines to go through.

The Million Dollar Question: Does anyone know if there is a way in Excel to index both the User ID and Role columns at the same time so that, for example, in cells A3 and B3 are compared against columns D & E in the other list and it returns a match on D4 & E4?

I don't need it to return the exact value...a message of "MATCH" or something would be perfect (not sure if that would be easier that way!).

Attached is an example so you can see what an example of my user lists would look like.

Thank you SO much in advance!