Automatically tagging text for data analysis

[martinofinotelli]

Hi everyone and thank you for reading this.

I have tried to play around with IF(ISNUMBER(SEARCH... but I did not obtain exactly what I needed.

Please, use the pic below as reference.

Column D is the input. Column E is the output. Normally I fill in column E manually depending on what is in column D (I pick it from a data validation list). If it is from twitter, youtube, facebook... I pick "social network" - If it is from my blog, I pick "Platform").

There are a few options so I will not list them all, but I guess you understood what I need. Would you be able to suggest a formula that would help me automatize this process?

For example: if D contains "twitter", "facebook", "youtube", then E is automatically "Social Network". If D contains "guardian", then E is "Article - external website"

Thank you