Find Latest comment for ID using vlookup/MAX?

[Nortonstired]

I would like use a vlookup or equivalent to pull the latest comment for a specific ID. I can’t figure it out. I’m thinking maybe MAX but I’m not using it correctly. I think i need the vlookup because I am filling in cells in another table with the latest comment for its ID. In this example I would need it to return for ID 345 - Brown, 678 - yellow and 123 - Blue. How would I achieve this? Thanks for your help!

Also, If the latest date has multiple results (ID 999) is a possible to have it return “research “ like I would do with a IFERROR formula?

ID	DATE	COMMENT
123	1/11/24	Blue
123	1/7/24	Green
345	1/1/24	Red
345	1/3/24	Brown
345	1/2/24	Orange
678	1/4/24	Purple
678	1/5/24	Yellow
999	1/4/24	Taupe
999	1/4/24	Sage

 

[KOKOSEK]

Could be something like this:

Book1
	A	B	C	D	E	F
2	ID	DATE	COMMENTS		ID	latest comments
3	123	01/11/2024	Blue		123	Blue
4	123	01/07/2024	Green		345	Brown
5	345	01/01/2024	Red		678	Yellow
6	345	01/03/2024	Brown		999	research
7	345	01/02/2024	Orange
8	678	01/04/2024	Purple
9	678	01/05/2024	Yellow
10	999	01/04/2024	Taupe
11	999	01/04/2024	Sage
Sheet1

Cell Formulas
Range	Formula
F3:F6	F3	=LET(a,FILTER($C:$C,($A:$A=$E3)*($B:$B=MAXIFS($B:$B,$A:$A,$E3))),IF(COUNTA(a)>1,"research",a))