next date in list greater than cell value

[tpowell1986]

hi,

we have a list of products has have been reported lost, i want to look at the list of transactions on another sheet to see if there is any further transactions after the date it was reported lost?

thanks in advance

i.e.

Vessel	Lost Date	Further Transactions		Vessel	date_out
7285165	08/04/2015	20/06/2021		7285165	01/01/2014
7759616	08/03/2018			7759616	02/01/2014
7759645	08/12/2015			7759645	03/01/2014
7759723	08/01/2018			7285165	20/06/2021
7759789	08/08/2016			7285165	23/06/2021

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1	Vessel	Lost Date	Further Transactions		Vessel	date_out
2	7285165	08/04/2015	23/06/2021		7285165	01/01/2014
3	7759616	08/03/2018			7759616	02/01/2014
4	7759645	08/12/2015			7759645	03/01/2014
5	7759723	08/01/2018			7285165	20/06/2021
6	7759789	08/08/2016			7285165	23/06/2021
Lists

Cell Formulas
Range	Formula
C2:C6	C2	=LET(Mx,MAXIFS(F:F,E:E,A2),IF(Mx>B2,Mx,""))

 

[tpowell1986]

thank you, it needs ideally to show the next date in the list so in this case cell f5 not the max date

 

[Fluff]

Ok, how about

=IFERROR(AGGREGATE(15,6,$F$2:$F$6/($E$2:$E$6=A2)/($F$2:$F$6>B2),1),"")

 

[tpowell1986]

Ok, how about

=IFERROR(AGGREGATE(15,6,$F$2:$F$6/($E$2:$E$6=A2)/($F$2:$F$6>B2),1),"")

thank you, much appreciated!

 

[Fluff]

You're welcome & thanks for the feedback.