Posted by Mel
In Sheet one I have this:
And on Sheet 2 i have
In B on sheet two I want it to return the last date that the name was present
When the list of source data is sorted, solution is simple,
you can use VLOOKUP, or OFFSET(or INDEX) combined with MATCH.
But, when list is unsorted, to use pure Excel formulas without macro is more complicated.
Then combined formula, where SUMPRODUCT is used might be solution.
TIP: to make formula not so immense, use named range, e.g. range with source names = xName