SEARCH function help

[narikisas]

Hi,

I'm trying to use SEARCH function to find out whether the email domain is a public domain or a corporate domain.

Column A has all the email ids
Column B is empty and i need to tag them as public domain / corporate domain -- Public domain as 1 and corporate as blank
Column C is empty and i need to tag the name of the public domain if it's corportate leave it as blank and if public - name it as yahoo/gmail/hotmail
Column D (D2:D10) has all the list of all the public domains like yahoo, gmail, hotmail etc

In column B - I'm trying to get the value as "1" if it's public domain or keep it as blank if its corporate
In column C - I'm trying to get the name of the public domain according to the value in column A - if it's corporate leave it as blank

I'm trying my luck with SEARCH function but unable to do so..

=IFERROR(SEARCH($D$2:$D$10,A:A),"")

[benishiryo]

hi narikisas. do provide an excel sample file next time for us to help you better. assuming data in A2, try this for B2:
=IF(ISNA(LOOKUP(2^15,SEARCH($D$2:$D$10,A2))),0,1)

and this for C2:
=IFERROR(LOOKUP(2^15,SEARCH($D$2:$D$10,A2),$D$2:$D$10),"")

[narikisas]

Thank you so much Sure will attach the sample excel sheet from next time on wards.