title: Excel: Search for a list of strings within a particular string using array formulas?
body: <p>I want to search a cell for a list of words.
  I thought this would work as an array formula:</p>
  
  <pre><code>{=FIND(&lt;list of words I want to search for&gt;,&lt;cell I want to search&gt;)}
  </code></pre>
  
  <p>But it only finds a match when a word that's in the cell I'm searching sits in the first row of the list of words I'm searching for.  Is there any way to write a formula that looks through the entire list?  And I'd prefer if it didn't just return TRUE/FALSE.  I know how to search cell for a list of words and return TRUE/FALSE based on whether or not a word in the list exists in the cell.  I want to actually know which word was found, or its position.</p>