I am trying to find a way to search a cell or a combination of cells, for key words that are in a separate list. The separate list is dynamic, meaning it will be changed, expanded, or contracted at various times.
I would also like the search to return a specified numeric value to a different cell if it finds one of these words. If it does not find one of the words I would like it to return a separate specified value.
I attached an example to help make things more clear.