Menu
Basicaly, I have 2 lists of email addresses in Excell...
Column A = Holds over 2051 rows of email addresses
Column B = Holds about 1994 rows of email addresses
I need a way to find out which email addresses in Column A aren't found in Column B, and preferably output the results in, either a new sheet, or in Column C.
Than after that I need to be able to find which email addresses in Column B aren't found in Column A (if any) and output that list into, either a new sheet or Column D.
How can I do this?
628
You can use the MATCH() function to check if the values in column A also exist in column B. MATCH() returns the position of a cell in a row or column. The syntax for MATCH() is =MATCH(lookup_value, lookup_array, [match_type]) . Using MATCH, you can look up a value both horizontally and vertically.
Navigate to the "Home" option and select duplicate values in the toolbar. Next, navigate to Conditional Formatting in Excel Option. A new window will appear on the screen with options to select "Duplicate" and "Unique" values. You can compare the two columns with matching values or unique values.
In either a new sheet or column C use a combination of VLOOKUP() and IFERROR() and drag that formula for every line of A.
=IF(ISERROR(VLOOKUP(A1, $B$1:$B$1995, 1, 0)), A1 & " NOT FOUND IN COLUMN B", "FOUND IN B")
This will return two different messages depending on if the e-mail was found or not in B.
117
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
