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),"")