title: Excel - lookup a range of data to match characters in string
body: <p>I googled like crazy before I came here.</p>
  
  <p>I have 2 columns of information (I have to use alternate data for privacy). See below.</p>
  
  <p>I would like in a 3rd column to look thru the list (or the range) of the first column and return the matching word. For example, I need the 3rd column for the first sentence (There is a cup on the counter) to say "CUP".</p>
  
  <p>I've tried all sorts of combinations of functions and I can't quite get it right. </p>
  
  <pre><code>1st column    2nd column                       3rd column
  Desk          There is a cup on the counter    **Result should be: Cup**
  Chair         You need to plug the cord in
  Cup           The desk is red
  Cord          I have a large computer
  Computer      I put the chair over there
  </code></pre>