Return latest date Part repair information from an array

I have a list of spare part repairs. Column A Repair date, Column B Part reference, Column C repair information. The same Part reference can appear in the list at subsequent repair dates.

How would I look up the array and return the latest date repair information from Column C.

Help appreciated

M

ps dummy file attached for clarification. Red text is the wanted result.