In my data there is a column with some description and I want categorize the text based on specific target words that appear in the cell. Here is what my data looks like:

Column A contains the raw description data. Column D and E show the target word-category pairs. For example, if the word “target1” is in the cell, I want the category associated with this cell to be “AA”. Column B is the result I am looking for. So for every cell in A we need to look up what target word from column D is present and put the associated category from column E in column B.

I tried different stuff with SEARCH and FIND but can not figure out how to solve this. In my actual use case the target words may be any strings and not only “targetX”.