Look Up Most Recent Date

In Column B of my current workbook I'm using this function:

Please Login or Register  to view this content.

This looks up the task number in A2 of my current workbook against the same task number in a workbook called "LookupBook" & returns a date the task was done.

However, "LookupBook" will have the same task number multiple times.

At present its looking up the first occurrence of that task number in "LookupBook" and returning that date when I need the date for the most recent occurrence of that task number instead.

Can anyone advise how to modify this function to look up the most recent date from "LookupBook" associated with that task.

Any help would be deeply appreciated.

I'm using Excel 2007.

Drop this code into VBA and it will be a 'reverse' vlookup that returns the last match instead of the first. the formula is exactly the same as =vlookup, but it starts =VarLookRev(.

In order to work, whole columns must be selected for the lookrange, not just part of them.

Please Login or Register  to view this content.

Let me know if it helps!