Retain Values Common In 2 Column Lists

  • I need to match e-mail addresses in two columns: in the first column, I have nearly 4000 addresses. In the second, I have approximately 300. I need to keep only those addresses that appear in both columns and eliminate the rest. Is there a function that will help me do this?

    Thank you!

  • Re: Match Values In Two Columns

    If your first list is in A1:A4000 and the second is in B1:B300, C1 could have =VLOOKUP(B1,A$1:A$4000,1,False). That will return an error message for every item in B that doesn't show up in A. In D1, =VLOOKUP(A1,B$1:B$300,1,False). Then you can just filter to the error messages and delete.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!