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

Posts
1
Registration date
Tuesday December 13, 2016
Status
Member
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.
=IF(ISNUMBER(SEARCH("Latency",D2)),"Latency",IF(ISNUMBER(SEARCH("launch",D2)),"Connection",IF(ISNUMBER(SEARCH("connect",D2)),"Connection",IF(ISNUMBER(SEARCH("Issue",D2)),"Issue""Other")))

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