Using your posted workbook...
This regular formula returns the first word in A2 that matches a word in the KEYWORDS list
C2: =INDEX(Keywords,MATCH(MIN(INDEX(SEARCH(Keywords,A2&Keywords),0)),INDEX(SEARCH(Keywords,A2&Keywords),0),0))
EDITED TO INCLUDE THIS COMMENT:
The above formula assumes that at least one of the keywords will be found on the list.
If that's not the case...
Put the words "No Match" at the top of the KEYWORDS list and that will display when that situation exists
Is that something you can work with?
Bookmarks