title: find last match in column using built in functions in excel
body: <p>I have an excel workbook with multiple instances of the same client ID.  So, a client can appear more than once in the list.  I would like to find the last (closest to the bottom) instance of the client ID so i can then look along that same row for additional information.  VLOOKUP shows the fist instance, I need the last.</p>
  
  <p>So, how do I find the last instance of a given client ID using built in functions?  I'd rather not write a macro to do this.</p>