Look up value, return adjacent cell

[carlidee]

Hello - Could someone please help me compose a formula for where the "???" currently stands to help return the corresponding name for lastest event in the data?

In this case, I would want the output to read "Completion"

Thanks!

Name	Date of latest event	Title of latest event	Event 1 Date	Event 1 Title	Event 2 Date	Event 2 Title	Event 3 Date	Event 3 Title
John	2/3/23	???	1/1/23	Round 1	1/15/23	Round 2	2/3/23	Completion

 

[JamesCanale]

MrExcelPlayground20 (version 1).xlsb
	A	B	C	D	E	F	G	H	I
24	Name	Date of latest event	Title of latest event	Event 1 Date	Event 1 Title	Event 2 Date	Event 2 Title	Event 3 Date	Event 3 Title
25	John	2/3/2023	Completion	1/1/2023	Round 1	1/15/2023	Round 2	2/3/2023	Completion
Sheet23

Cell Formulas
Range	Formula
C25	C25	=IFERROR(INDEX(D25:I25,MATCH(B25,D25:I25,0)+1),"")