title: Get VLOOKUP to pick most recent date from a selection
body: <p>Is it possible to get an Excel VLOOKUP to pick out the most recent date where it finds multiple lookup values:</p>
  
  <p>e.g. this is what I have at the moment:</p>
  
  <pre><code>=IFERROR(VLOOKUP(A$1:A$5635,'RSA Report'!A:V,21,FALSE),"")
  </code></pre>
  
  <p>it would currently pick (User1 acting as the value that is being looked up)</p>
  
  <pre><code>Col A (1)                       Col U (21)
  User1                           22/10/2013
  </code></pre>
  
  <p>from </p>
  
  <pre><code>Col A (1)                       Col U (21)
  User1                           22/10/2013
  User1                           28/03/2014
  User1                           22/10/2013
  User1                           28/03/2014
  </code></pre>
  
  <p>whereas I want it to pick</p>
  
  <pre><code>Col A (1)                       Col U (21)
  User1                           28/03/2014
  </code></pre>