Return Value from Lookup with Multiple Criteria, one being the largest date.

[pLethora]

Thanks in advance.

I am trying to return the value in the "Due Date" column while using the criteria of Name and then only return the most recent data of the "Date" Column.
Example: Looking up "Lee" in Name Column and the latest data for "Lee" being 02/04/2022 in the "Date" Column which would return the "Due Date" 13/06/2022.
Returning Blank value's is perfectly fine. This is due to a need to keep pasting in data which may have duplicates as well as updated data in the "Due Date" Column which must only return the latest date results.

Could not find anything that would solve my issue.

Date	Name	Due Date
01/04/2022	Lee
01/04/2022	John
01/04/2022	Adam
02/04/2022	John
02/04/2022	Lee	13/06/2022
02/04/2022	Adam	17/06/2022

 

[arthurbr]

Perhaps

=MAXIFS(C2:C7,A2:A7,MAXIFS(A2:A7,B2:B7,"lee"))

 

[pLethora]

Perhaps

=MAXIFS(C2:C7,A2:A7,MAXIFS(A2:A7,B2:B7,"lee"))

Thanks, that didnt quite work the way i needed it to but it kicked started my brain to use:
=MAXIFS(C:C,A:A,MAXIFS(A:A,B:B,G2),B:B,G2) which did what i needed. Thank you.

 

[pLethora]

Thanks, that didnt quite work the way i needed it to but it kicked started my brain to use:
=MAXIFS(C:C,A:A,MAXIFS(A:A,B:B,G2),B:B,G2) which did what i needed. Thank you.

G2 being the Name.