EXCEL 2013 :Searching for text and display a different value. [Solved/Closed]

Registration date
Tuesday December 13, 2016
Last seen
December 13, 2016
I am fairly new at this, but I work in excel files that are extracted from out problem management system. I created a formula that will look for a key word and if found display a value in another cell. It works, but wondering if there is a different way to achieve the same results. Thankyou in advance.

Techs tend to close tickets using "other", so I am parsing through to identify problems.
See more