Originally Posted by Max

One try ..

Assuming the data for both POTENTIAL CUSTOMER and ESTABLISHED CUSTOMERS are
listed in col A, in A1 down in sheets named as:
Potenial, Established

In sheet: Potenial

Put in B1:
=IF(ISNUMBER(MATCH(A1,Established!A:A,0)),"Yes","N o")
Copy down as far as required (to B600?)

Col B will return a "Yes" next to any cust which is found
in the sheet: Established, "No" otherwise.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"farrell" wrote in message
...

Hi! Thank you for taking the time to read this.

I run an internet retail business. We advertise on search engines
large and small.

I have to make a decision on whether or not one of our smaller ad sites
is paying off. Basically, the ad site supplies us with a list of
POTENTIAL CUSTOMER emails. We send out monthly promotional emails to
them.

Now i need to track these emails to see if any of them have become
ESTABLISHED CUSTOMERS.

So far, I fed information from our main data base of ESTABLISHED
CUSTOMERS into EXCELL so all the ESTABLISHED CUSTOMER emails are in one
column.

But i don't know what to do next. I have 600 POTENTIAL CUSTOMER emails
that i need to check against the established list. The only way i can
think of , with my limited Excell knowledge, is searching using the
editfind function one by one until i'm done with the list of 600
emails.

I know there's a better way!!!

Can anyone help?


--
farrell