If Vlookup Value is less than this column cell, return next vlookup Value that's higher than this column cell

[WHGRexcel]

Hello Guys,

First time poster. Love the site. I have this advanced excel problem that hopefully you guys can help out. I have two tabs: First tab contains an entry for each unique account ID and each date(s) they saw a login error. The 2nd tab contains an entry for each unique accountID and each date(s) they successfully logged in.

I want to do the following: I want to understand how many users from the first tab exist in the 2nd tab, from there, return the closer successful login date that is greater than the unsuccessful login. For example:

1st Tab - Unsuccessful Logins

Unique ID (Column A)	Login Unsuccessful (Column B)	Dates (Column C)
654877​	Login Unsuccessful	20210220
654877​	Login Unsuccessful	20210225
126257	Login Unsuccessful	20210205
624982	Login Unsuccessful	20210207

2nd Tab - Successful Logins

Unique ID (Column A)	Login Successful (Column B)	Dates (Column C)
654877​	Login Successful	20210201
654877​	Login Successful	20210223
654877​	Login Successful	20210227
126257	Login Successful	20210207
624982	Login Successful	20210205

On the next Column on the first Tab, I want:

Unique ID (Column A)	Login Unsuccessful (Column B)	Dates (Column C)	Next Successful Login Date (Column D)
654877​	Login Unsuccessful	20210220	20210223 (Successful Login C3)
654877​	Login Unsuccessful	20210225	20210227 (Successful Login C4)
126257	Login Unsuccessful	20210205	20210207
624982	Login Unsuccessful	20210207	"no" [login value is lower than login error value]

Hopefully I gave you enough information. Any help would be greatly appreciated! Thanks!

 

[WHGRexcel]

By the way, I know how to return the first or last value in a vlookup, but not sure how to add an If condition if the vlookup value is lower, return the next value.

I was playing around with If/Large/Vlookup, but I don't think it would work as intended (=IF(VLOOKUP(A6,'LOGIN SUCCESSFUL'!$A$2:$F$45857,3,0)>=E6,LARGE(VLOOKUP(A6,'LOGIN SUCCESSFUL'!$A$2:$F$45857,3,0),">"&J6),"no"))