Hi everyone. Help wit Excel!

[AliaNi]

ID	IN	OUT	PRIMARY AREA	FINAL AREA	ID nEXT
5.00​	1/5/24 4:24 AM​	1/12/24 4:46 PM​	1115	1115	7​
7.00​	1/12/24 6:49 PM​	2/6/24 8:10 PM​	1115	1111	#N/A​
4.00​	1/19/24 7:58 PM​	1/23/24 7:00 PM​	1115	1115	2​
2.00​	1/24/24 11:14 AM​	1/26/24 3:46 PM​	1115	1115
1.00​	1/26/24 9:59 AM​	1/27/24 5:05 PM​	1115	1115
3.00​	2/6/24 11:35 PM​	2/9/24 12:20 PM​	1115	1115
6.00​	2/7/24 12:32 PM​	3/3/24 1:00 PM​	1115	C9

 

[AliaNi]

I want to get ID Next. So Look at Final Area from Cell 1 associated with ID = 5 and get see what ID is associated with the next time the same Area is Filled as Primary Area which in the first cell it would be 7.

 

[StephenCrump]

A similar question is answered here: Excel Formula.