Email account list reconciliation

We have two different lists of email addresses. The first list is in Column A and the second list of email addresses is in column B.

I'd like to set up a function that would list all email addresses in column C that are listed in column A and are not listed in column B.

Another function that lists all email addresses in column D that are listed in column B that are not in column A.

We have two user databases here and need to reconcile a list of users. These two functions will leave us with a list of only active employees.

Any tips?

Hi,
you can create a solution using the VLOOKUP function.

Assuming your data has 100 rows and starts at A1

Column A - 1st list of email addresses
Column B - 2nd list of email addresses

Column C - =IF(ISERROR(VLOOKUP(A1,$B$1:$B$100,1,FALSE)),A1,"")
copy this formula down the whole table
it looks if the email address in A1 can be found in the range B1:B100. If not, it will return an error to the function and the email address in column A will be displayed in column C.

Column D - =IF(ISERROR(VLOOKUP(B1,$A$1:$A$100,1,FALSE)),B1,"")
copy this formula down the whole table.

Make sure to include the $ signs in the range, otherwise the formula will change this reference when you copy the formula down.

Hope this helps

Teylyn