Return latest information from another worksheet

[SerenityNetworks]

I need to return the latest/last information, by date, from Sheet 2 into Sheet 1. The following mini-sheet shows in Sheet 1, Columns C and D the information that needs to be returned from Sheet 2, Columns H and G. The "Name" column is the search criteria. The Name may appear more than once in each worksheet, but I only want the latest/last information returned from Sheet 2. I'm at a loss as to how to do this, since the data order will change in both sheets. I can't count on the information being sorted in ascending or descending order in either of the sheets. I could use a macro to sort the data then use a lookup or match function to return the data, but I'd rather do it with a formula than utilizing macros. How is this doable?

Thanks in advance,
Andrew

Book1
	A	B	C	D	E	F	G	H
1	Sheet 1					Sheet 2
2	Class	Name	Latest Yes/No value from Sheet 2	Corresponding Date from Sheet 2		Name	Date	Yes/No
3	1	Bob	Yes	03/01/2023		Bob	01/01/2023	No
4	5	Bob	Yes	03/01/2023		Jill	01/01/2023	Yes
5	3	Jill	No	03/01/2023		Bob	03/01/2023	Yes
6	1	Jill	No	03/01/2023		Jill	03/01/2023	No
7	2	Wanda	No	02/01/2023		Ziggy	02/15/2023	Yes
8	3	Bob	Yes	03/01/2023		Wanda	02/01/2023	No
9	4	Ziggy	Yes	02/15/2023		Bob	02/10/2023	No
10	5	Jill	No	03/01/2023		Jill	02/10/2023	No
Sheet1

 

[SerenityNetworks]

Never mind. I'm not sure why I had such a brain cramp. Once I remembered MAXIFS then the brain cramp relaxed and I was off and running.

question.xlsx
	A	B	C	D	E	F	G	H	I
1	Sheet 1						Sheet 2
2	Class	Name	MM/YY	Latest Yes/No value from Sheet 2	Corresponding Date from Sheet 2		Criteria 1	Date	Yes/No
3	1	This	12/22	Yes	03/01/2023		This	01/01/2023	No
4	5	This	02/23	Yes	03/01/2023		That	01/01/2023	Yes
5	3	That	02/23	No	03/01/2023		This	03/01/2023	Yes
6	1	That	12/22	No	03/01/2023		That	03/01/2023	No
7	2	Another	01/23	No	02/01/2023		Other	02/15/2023	Yes
8	3	This	02/23	Yes	03/01/2023		Another	02/01/2023	No
9	4	Other	02/23	Yes	02/15/2023		This	02/10/2023	No
10	5	That	02/23	No	03/01/2023		That	02/10/2023	No
Sheet1

Cell Formulas
Range	Formula
D3:D10	D3	=INDEX($I$3:$I$10,MATCH(1,($H$3:$H$10=$E3)*($G$3:$G$10=$B3),0),1)
E3:E10	E3	=MAXIFS($H$3:$H$10,$G$3:$G$10,B3)