comparing two lists for matches

Hello all,

I am trying to compare a large list of email addresses against a smaller list of addresses. My purpose is to write out a third list containing the entries from the larger list that do NOT have a match in the smaller list. The two lists are in adjacent columns on the same worksheet and I want the third list to be in another column. I would like to avoid blank cells in the third list, so it will be shorter than the Master and will not align row by row. The two original lists are designated with named ranges "MasterList" and "DropList".

If I have done it correctly, a .doc word file is attached with a copy of my attempt so far.

Thanks in advance for any help.

Conor

Thanks for the reply. That formula works for the first cell, c2, but not for any cell below it. I can use your approach if you can supply a tweak. Every cell below c2 shows #NUM. Thanks.

Thanks. This works very nicely. For any other readers, my confusion arose because I copied and pasted the formula from your reply. That part is fine, but a user needs to edit the formula (just click in it somewhere) on the formula in order to apply the array characteristics with ctrl+shift+enter. Then it can be copied. Thanks again.