Should you have email in col F which is not found in col E,
then better to withhold this action ..

If desired, copy col G and overwrite col F
with a paste special as values, then clean up by deleting col G

To check & retrieve any email in col F which is not found in col E

Put in I1:
=IF(F1="","",IF(ISNUMBER(MATCH(F1,E:E,0)),"",ROW() ))

Put in J1:
=IF(ROW(A1)COUNT(I:I),"",INDEX(F:F,MATCH(SMALL(I: I,ROW(A1)),I:I,0)))

Select I1:J1, copy down to the last row of data in col F

Col J will return email in col F which is not found in col E,
with all results neatly bunched at the top
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---