Conditional VLOOKUP + MAX date formula

Hello. I am having issues trying to meet a request. The request is that for a very large report, I need to produce the MAX (or most recent) date in column S for each name in column D, so long as the value in column I = "Annual Update (B)"

I tried a pivot table to return max date as values with the Report Filter = "Annual Update (B)" only, but I only get values of 0. Then I tried this, with all the unique names on a separate worksheet in column B and this formula in column C next to each name and it fails. Please help!

Please Login or Register  to view this content.

I love that, but it doesn't work. I tried everything. Please take a look at the attached. Maybe this is a formatting issue. Thanks for helping!!Copy of zzControlSheets_2004_To_041515 for Forum.xlsx

I got it working. Looks like there was a copy/paste error with the formula you provided. I did it again and now it works like a charm. Thank you!!