title: Excel: retrieve all values from column 2 having the same column 1 value
body: <p>I have a table in MS Excel. i want to retrieve a list of all corresponding values in a different column having the same first column value. For example, from a State's  monthly weather data table I need all mintemp and maxtemp of all days having the same location. </p>
  
  <pre><code>location     date      mintemp        maxtemp
  A           7/1/14        61             84
  A           7/2/14        65             89
  A           7/3/14        70             75
  B           7/1/14        32             40
  B           7/2/14        29             42
  </code></pre>
  
  <p>Say I want only A's data. <code>VLOOKUP</code> function will extract only one value of <code>A</code> from this table. I could take a combination of location and date and use in <code>VLOOKUP</code> but that's a big deal.</p>