Assign words by selecting a common word

Hello,

I have a raw dump sheet, which has case details. there is a Description Column. I want to insert a column next to in and assign keywords depending on the kind of description.

Example: if the description contains "Service: HTTP Thread Saturation" the Keywords column should update as "Zimba Error"

Can u help me on this