Excel 2007 : Finding a text with a string of text

[cceze]

I have a list in column A and I want to search for a text in columns A string of text and return that text in column B. I used an IF(Search) statement and it worked for some rows but not all of them. how can i fix this?
I attached a sample

this is the IF statement in full:
=IF(SEARCH("Pharma",$A2),"Pharma",IF(SEARCH("MD&D",$AO3),"MD&D",IF(SEARCH("Consumer",$A2),"Consumer")))

thanks!