Hi

I have a problem that I would your help with. I have attached a spreadsheet.

I need a formulae in sheet 2 that looks at sheet 1. Within a defined date range. That looks at any cell with a #AAA (AAA being an employee initials) It needs to find the last # in that defined date range then look up to the date. The date is what I need to be presented.

Hopefully the attached sheet will show what is needed.

Help.xlsx

Thank you,