VLOOKUP returning values with the most recent date

Hi Everyone,

I'm new to this forum and I apologize if this a silly question that has already been answered quite a few times. My basic VLOOKUP formula returns the first instance of the value it can find, however in those cases when there is more than one value available, i'd like to use the one with the most recent date. Please see the example attached.

I can certainly just sort my entries from latest to oldest date and then run VLOOKUP, but i'd like to see whether it is possible to get this done without sorting.

Many thanks!!!