I have worksheet A with column A with e-mail
)...
In worksheet B column A with URL's:
www.somewhere.com----

I would like to check worksheet A e-mail addresses against the URL's of
worksheet B...meaning somehow come up with a function to display in
column B of worksheet A "ADVERTISER".

So in theory, I have to use something like
=IF(COUNTIF($A$1:a1,A1)1, "ADVERTISER", "Non-advertiser"
but gear it to after the @ in worksheet A. And since all the e-mail
addresses are different, can't use character count. It would also
reference the URL's in workshhet B and since they are all www. I could
use character count or something...

If someone could HELP me, I would be so thankful. :)


--
rae820
------------------------------------------------------------------------
rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
View this thread: http://www.excelforum.com/showthread...hreadid=377527