title: Excel - If a Cell contains a value from an Array, extract that value
body: <p>I can't find a way to make this work. I hope that maybe someone can help me with this.</p>
  
  <pre><code>The cell A2 contains the following: "Star Wars Lotion Pump"
  
  My array contains (C1:C5) the following:
  C1: Categories
  C2: Pen
  C3: Clock
  C4: Watch
  C5: Lotion
  </code></pre>
  
  <p>In the cell B2 the formula should return "Lotion" or in case there is no match just a "".</p>