deleting rows that is compared to a single column.

[treeroot]

Ok my company sends out email blasts through constant connect and say a
thousand or so emails are in correct so I exported the bonce back emails and
have them on a single column worksheet, so now I want to take that single
column and pull all of the bad emails out of my master list. And in my
master list I have a complete row on the contact say, first name, last name,
phone number, address, and then their email address. So I want to pull the
whole row with the bad email. No clue how to do it. .....Help

 

[Sheeloo]

One way is to do VLOOKUP
Assuming bad emails are in Col A in Sheet 2 and your data is in Sheet 1 with
emails in Col A
Enter the following in an empty column and second row (assuming first row is
header row)

=VLOOKUP(A1,Sheet2!A:A,1,FALSE)

Wherever you get an email address is the bad row. You can filter on NOT
EQUAL to #NA and delete those rows.