Email account list reconciliation

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