Vlookup most recent date/service date

[jee335]

I am trying to incorporate two sheets. One is to show me what the most recent service date of one serial number is and one is to show me an entire log of the service dates.

I cant seem to get the dates to work right. When I first started, it was taking dates of just the first service date, obviously we will have multiple dates for each serial number.

here is the file

http://www.mediafire.com/file/huc4adryqqf65p3/inventory.xlsx

Thanks in advance

 

[jee335]

I actually just did a pivot table on the same sheet, that seemed to do the trick