title: Searching for multiple specific words in Excel
body: <p>I've seen several examples of Excel formulas that can search for multiple words in a cell like so:</p>
  
  <pre><code>=IF(SUMPRODUCT(--(NOT(ISERR(SEARCH({"mail","post"},A4)))))&gt;0,1,"")
  </code></pre>
  
  <p>And:</p>
  
  <pre><code>=OR(NOT(ISERR(SEARCH("mail",A4))),NOT(ISERR(SEARCH("post",A4))))
  </code></pre>
  
  <p>However, the results will pick up any instance of "mail" (i.e. "mail" or "email") or "post" (i.e. "post" or "posture"). Is there a way to run a search for multiple words and only the specific words listed?</p>