Using Search and Lookup/Match/Index Functions

Hello everyone,

I have a challenging question. I am trying to lookup for a specific word / phrase inside an excel cell then return a value of 1,2 or 3.
I was able to use the Search function alone, but was not able to combine it with either a Lookup / Match / Index function.
Can someone please help. I have attached a sample file to illustrate my issue.

Thanks so much!
Lucas