Make vlookup pick the latest date or comments in the list

Hi Everyone,

How can i make vlookup pick the most recent comments in the list without having to arrange the dates in descending?

I have a comments field in the main tab (see excel sheet attach) which fetch information from the comments tab. I am using vlookup for this, however, vlookup picks the first match it finds, so if i don't sort the dates into descending it will pick the wrong comment.

Thanks in advance.