Need help with vlookup in duplicate values

Hi all,

I am working with an excel file with multiple duplicate values for the columns "Reference". While using the lookup function, I want to return the "Remarks" against each "Reference" for the most recent "Date". See data below.

Date Reference Remarks
1-Jan abc Test 1
1-Jan bcd Test 2
3-Jan def Test 3
2-Jan abc Test 4
1-Jan bcd asd
3-Jan abc faf

If I use the standard lookup function, the output will be as below:

Reference Remarks
abc Test 1
bcd Test 2
def Test 3

However I need the following output:
Reference Remarks
abc faf
bcd asd
def Test 3

Let me know how this can be done.

Sorry, my bad. Here is the corrected data:

Date Reference Remarks
1-Jan abc Test 1
1-Jan bcd Test 2
3-Jan def Test 3
2-Jan abc Test 4
2-Jan bcd asd
3-Jan abc faf

PL see attached file with formula.