title: Excel formula or vlookup to pick latest date?
body: <p>i am using vlookup and want to have the latest date to be picked from multiple entries as listed below, please advise if any one can help in this regard. </p>
  
  <p><a href="https://i.stack.imgur.com/pPH42.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pPH42.png" alt="Latest Date"></a></p>
  
  <p>Now i want to pick latest date for ALi, Mubeen and Nadeem from the corresponding column of date. e.g i can pick Ali and latest date for this one is 5-Dec-20.</p>
  
  <p>Please advise.</p>