Lookup the most recent occurance of an input, and the return the value from another column

[D.Lovell]

Hi All,

Please see the attached example....


Column A has a line number.

Column B has dates and there are duplicates.

Column C is the lookup value.

Column D is the value to return.


I want to return the value in column D, where column C has the most recent occurrence of something, I have just used a 1 letter text example 'A'.

This should take into account both the date and the line number. Where there are multiples of 'A' entered into column C for the same date, I want to find the lowest one down in the list by line number, and then return the value in column D.


Many thanks in advance for any insight,