How to extract multiple words from one cell

I am trying to search a single Cell and extract different words to summarize issues.

I am extracting ticket data which includes Short Desc, Desc and resolution. I have concatenated those 3 fields into one field(one cell which is D2)
I want to search cell D2 and extract different words which can allow me to quickly categorize issues.

In cell A2 i have entered the following formula:

=IF($D2="","",
IF(ISNUMBER(SEARCH("missing",$D2)),"Missing",
IF(ISNUMBER(SEARCH("new",$D2)),"new",
IF(ISNUMBER(SEARCH("*upgrade*",$D2)),"upgraded",
IF(ISNUMBER(SEARCH("*error*",$D2)),"error",
" ")))))

It works but only returns the first value found. Is there a way to return ALL matches found? See attachedBook1.xlsx