title: Assigning categories based on cell containing a string
body: <p>I would like to fill in the category cell of this example</p>
  
  <pre><code>Date        Description    Debit    Category
  
  15/07/2011  Farmer Smith    10      
  </code></pre>
  
  <p>based on an other worksheet containing mapping values like this :</p>
  
  <pre><code>Farmer  | Groceries
  </code></pre>
  
  <p>I think I have to use a VLOOKUP but it doens't seem to "search" for the term ( farmer ) inside the Description cell, how do I tell my VLOOKUP to search the cell if it CONTAINS the first value and the mapping table and return the second column ( groceries ) .</p>
  
  <p>Thank you</p>