‘VLOOKUP’ Formula To Calculate Latest Date Associated To ‘Parent’ Record

Hi,

can anyone please advise me of the ‘VLOOKUP’ formula I require to find the latest date for each ‘Parent’ record.

Basically, I have a worksheet with data in the ‘Parent’ record from columns ‘A’ to ‘AU’, however, in column ‘T’ (Note) which is text and column ‘U’ (Note Creation Date) which is a date format (dd-mm-yyyy) where it contains a list of notes associated to the parent record and the date it was created.

In the attached file (Example data.xlsx' the ‘Parent’ records are in rows 2. 61. 68 and 86 and can numerous ‘Child’ records associated i.e. zero entries, 1 enrty, or numerous entries

What I require (I think) is a ‘VLOOKUP ‘formula to calculate the latest date for the note and the note itself for each ‘Parent’ record and enter this data on the ‘Parent’ row in column ‘V’ (Latest Note) and Column ‘W’ (Latest Date)

Any assistance would be greatly appreciated

Many thanks in advance

Regards

Rob


N.B. Excel Version 2010