Pull most recent description if not marked complete

[Amosbroker]

Hello,

I have the following spreadsheet:

I need to be able to pull the most recent description under project plan that does not have an X next to it under the complete column. I have an overview page, and I am attempting to list the next outstanding step that has not been marked X for complete. Would someone assist me with this? I have been fighting with an array formula but no luck this morning. Any help would be greatly appreciated. Many-SUPER thanks!

Project Plan Template	Start Date	End Date	Duration	Complete	Completion
Feed	2/1/21​	2/1/21	0	X
Kick off call	2/1/2021​	2/9/2021​	6​	X	3.6%
Send all applicable specs	2/17/2021​	2/17/2021​	0​	X	3.6%
Feedback	2/17/2021​	2/17/2021​	0​

 

[Toadstool]

Hi Amosbroker,
I'm not sure what's meant by 'most recent' so I've assumed latest End Date.

amosbroker.xlsx
	A	B	C	D	E	F	G	H	I
1	Project Plan Template	Start Date	End Date	Duration	Complete	Completion			Result
2	Feed	2/1/2021	2/1/2021	0	X				Feedback
3	Kick off call	2/1/2021	2/9/2021	6	X	3.60%
4	Send all applicable specs	2/17/2021	2/17/2021	0	X	3.60%
5	Feedback	2/17/2021	2/17/2021	0
6
Sheet1

Cell Formulas
Range	Formula
I2	I2	=IFERROR(INDEX($A$2:$A$10,AGGREGATE(15,6,ROW($A$2:$A$10)-ROW($A$1)/(($C$2:$C$10=(AGGREGATE(14,6,$C$2:$C$10/($E$2:$E$10<>"X"),1)*($E$2:$E$10<>"X")))),1)),"")