Excel: Searching a cell for keywords

If you need to search through various sentences for keywords, you can use SEARCH and TEXTJOIN together:

=TEXTJOIN(", ",TRUE,IF(IFERROR(SEARCH(keywords,A2),FALSE),keywords,""))

where keywords is the reference holding all the keywords to search.