Challenging Duplicate Question...

[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.

[Duke Carey]

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.


"rae820" wrote:

>
> 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.
>
>
> --
> rae820
> ------------------------------------------------------------------------
> rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
> View this thread: http://www.excelforum.com/showthread...hreadid=377527
>
>

[rae820]

thank you so much. I guess I didn't look at it like that at all. Just needed to step outside the box on that I guess

[Duke Carey]

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.


"rae820" wrote:

>
> 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.
>
>
> --
> rae820
> ------------------------------------------------------------------------
> rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
> View this thread: http://www.excelforum.com/showthread...hreadid=377527
>
>

[Duke Carey]

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.


"rae820" wrote:

>
> 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.
>
>
> --
> rae820
> ------------------------------------------------------------------------
> rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
> View this thread: http://www.excelforum.com/showthread...hreadid=377527
>
>

[Duke Carey]

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.


"rae820" wrote:

>
> 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.
>
>
> --
> rae820
> ------------------------------------------------------------------------
> rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
> View this thread: http://www.excelforum.com/showthread...hreadid=377527
>
>

[Duke Carey]

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.


"rae820" wrote:

>
> 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.
>
>
> --
> rae820
> ------------------------------------------------------------------------
> rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
> View this thread: http://www.excelforum.com/showthread...hreadid=377527
>
>

[Duke Carey]

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.


"rae820" wrote:

>
> 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.
>
>
> --
> rae820
> ------------------------------------------------------------------------
> rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
> View this thread: http://www.excelforum.com/showthread...hreadid=377527
>
>

[Duke Carey]

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.


"rae820" wrote:

>
> 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.
>
>
> --
> rae820
> ------------------------------------------------------------------------
> rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
> View this thread: http://www.excelforum.com/showthread...hreadid=377527
>
>

[Duke Carey]

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.


"rae820" wrote:

>
> 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.
>
>
> --
> rae820
> ------------------------------------------------------------------------
> rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
> View this thread: http://www.excelforum.com/showthread...hreadid=377527
>
>

[Duke Carey]

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.


"rae820" wrote:

>
> 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.
>
>
> --
> rae820
> ------------------------------------------------------------------------
> rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
> View this thread: http://www.excelforum.com/showthread...hreadid=377527
>
>

[Duke Carey]

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.


"rae820" wrote:

>
> 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.
>
>
> --
> rae820
> ------------------------------------------------------------------------
> rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
> View this thread: http://www.excelforum.com/showthread...hreadid=377527
>
>