title: MATCH or VLOOKUP starting from the end of the range
body: <p>I have a table that looks like this</p>
  
  <pre><code> A      B    
  ID1  data 123
  ID2  data 234
  ID1  data 456
  ID2  data 567
  </code></pre>
  
  <p>I am trying to find the best way to retrieve <code>data 567</code> for ID2.
  Using MATCH (with option 0) or VLOOKUP (with option FALSE) on ID2 gives me access to the first record but I want to retrieve the last record.</p>
  
  <p>I am using Excel 2010.</p>
  
  <p>ps: I'd rather not use VBA or manipulate the data (sorting...).</p>