Challenging Duplicate Question...

  • Thread starter Thread starter rae820
  • Start date Start date
R

rae820

I have worksheet A with column A with e-mail
addresses:([email protected])...
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. :)
 
Why not just split the e-mail addresses by using
Data>Text-To-Columns>Delimited and telling Excel to use the @ sign as the
delimiter. Then you'd have the domain name separately & you could prefix it
with the WWW. if you wanted to, in order to simplify the comparisons.
 
thank you so much. I guess I didn't look at it like that at all. Jus
needed to step outside the box on that I gues
 
Back
Top