title: Excel Formula - If contains text, result text
body: <p>I've got a weird Excel problem that is giving me a mind block. Basically, this is what I've got:</p>
  
  <p>Column A contains strings of text, which all contain company names and a bunch of other info. I'd like to strip out those names. I've got a list of the names I'm searching for.</p>
  
  <pre><code>**Contractor**
  CompanyA
  CompanyB
  CompanyC
  CompanyD
  </code></pre>
  
  <p>And strings like this:</p>
  
  <pre><code>CompanyA REQ# G-FMR-036 PT 2
  CompanyA Pad AN Structural Steel ()
  COMPANYC REQ# 54
  CompanyA REQ# G-FMR-049
  </code></pre>
  
  <p>What I would like is the formula to return whichever of the company names appears in that string. My first thought was a giant nested formula of IFs and SEARCHes but I know there has to be a better way.</p>