Assuming your data starts from A1 use the below formula in B1...which will
return "Present" if present in colD.

=IF(TRIM(A1)=D:D,"Present","")

If this post helps click Yes
---------------
Jacob Skaria


"Shaz" wrote:

I have 500 email addresses in column D and 13,000 in column A. Now i want to
delete all of the column A except the ones which are also in column D.

in other words I want to locate 500 contacts within our entire database of
13,000 checking it on email address. Can any body help please?