Compare/LookUp Value in List and Give Result

[cchrisj]

I am cleaning a customer database. I want to remove all accounts with bad email addresses. I have a list of the bad email addresses (a subset of all accounts). I want to compare/lookup if a bad email is in the account list and if it is, give a result of 1 (or some other identifying characteristic). I am looking for exact matches of email addresses.

Tried attaching sample, but it isn't working. Here is a link to a Sample on Google drive:

https://drive.google.com/open?id=0B0...DVHdllyNG1aQ0U

Thanks.

[Pete_UK]

You can put this formula in cell I3:

=IF(ISNUMBER(MATCH(H3,$K$5:$K$8,0)),"bad","ok")

then copy down. Then you could apply a filter to that column to display all the "bad" records, and then delete them in one operation.

Hope this helps.

Pete

[AlKey]

Or you can use formula to return TRUE or FALSE

Please Login or Register  to view this content.

v	H	I	J	K
2	Email
3	[email protected]	TRUE
4	[email protected]	FALSE		Bad_Email_List
5	[email protected]	TRUE		[email protected]
6	[email protected]	TRUE		[email protected]
7	[email protected]	TRUE		[email protected]
8	[email protected]	FALSE		[email protected]
9	[email protected]	TRUE
10	[email protected]	FALSE
11	[email protected]	FALSE
12	[email protected]	TRUE
13	[email protected]	TRUE

[cchrisj]

Wow. Perfect. Thanks!