How to: Search cell for multiple criteria, enter value in adjacent cell

[enlas]

Hello,

In column F I have a list of URLS. I want to search each cell in F to see if it contains any one of my keywords. If it does, I want to insert the corresponding keyword in G.

Entering =IF(ISNUMBER(SEARCH("*psychosis*",F2)),"psychosis","") in G2 returns "psychosis", but how do I have it search for all of my keywords and input it's corresponding category in G??

Thank you in advance for any & all help.

URL
http://www.privateurl.com/psychosis
http://www.privateurl.com/cold-flu/best-remedies-stomach-flu
http://www.privateurl.com/allergies/mosquito-bite
http://www.privateurl.com/dextrose
http://www.privateurl.com/tick-bites

Keyword	Category
psychosis	Psychosis
cold-flu	Cold & Flu
allergies	Allergies
tick-bites	Tick Bites

<tbody>
</tbody>

 

[konew1]

Are your keywords always the next word after "http://www.privateurl.com/" and either the last word in the URL or followed by "/"
If so, then the word to be checked can be extracted and compared to a key word list using =match or =lookup