title: excel vlookup with multiple results
body: <p>I am trying to use a vlookup or similar function to search a worksheet, match account numbers, then return a specified value. My problem is there are duplicate account numbers and I would like the result to concatenate the results into one string.</p>
  
  <pre><code>Acct No   CropType
  -------   ---------
  0001      Grain
  0001      OilSeed
  0001      Hay
  0002      Grain  
  </code></pre>
  
  <p>Is in the first worksheet, on the 2nd worksheet I have the Acct No with other information and I need to get all the matching results into one column on the 2nd worksheet ie. "Grain Oilseed Hay"</p>