title: Use partial match to set category in Excel
body: <p>I have exported my bank statement as a csv. In the Description column it shows things like "SPROUTS FARMERS MKT#28 PRESCOTT VALL  AZ" (where I buy my food) and "ARCO 428810 AMPM PRESCOTT AZ" where I usually buy gas.</p>
  
  <p>I would like to search for a partial match on "SPROUTS" and label those rows as FOOD in the category column. Likewise, a search for "ARCO" and label those rows as AUTO EXPENSE in the category column. </p>
  
  <p>Running several of these kinds of searches would result in most of my expenses being categorized. The rest I'll do by hand. </p>
  
  <p>I think VLOOKUP might be useful here, but can't figure out how I would use it to add the label in the category column.</p>
  
  <p>Appreciate any help :)</p>