title: If cell contains 1 or more keywords, change value of a different cell
body: <p>I have a column with some string description in it.</p>
  
  <p>for example:<pre>
  Bob davids
  mowing the lawn
  tipping cows</pre></p>
  
  <p>In addition I will have on a different sheet or column a list of keywords
  For example work keyword list 1:</p>
  
  <pre>
  davids
  work</pre>
  
  <p>play keyword list:<pre>
  mowing
  cows</pre></p>
  
  <p>So as the main column is populated with these text strings, I would like them checked automatically each keyword list to see if those words exist, and when it finds a match, place the title of the list (work/play) in the cell next to it.</p>
  
  <p>I know this is possible in VBA and can even do it "on the fly" in <code>SelectionChange</code> function.  But is this possible to do without VBA such as a conditional formatting?</p>