Vlookup from A data set to B and unique result should be higher than unique key data set A

[Rajesh]

Lookup TB Date to TR date and Filter out all lines where Date is higher than Date in TB

TB		TR
Date	Balance		Date	Balance
5/24/2023	212		5/25/2023	545
5/24/2023	12		5/25/2023	3535
5/24/2023	331		5/25/2023	3535
5/24/2023	212		5/25/2023	545
5/24/2023	212		5/23/2023	545
5/24/2023	212		5/23/2023	545
	Result
	Date	Balance
	5/25/2023	545
	5/25/2023	3535
	5/25/2023	3535
	5/25/2023	545

[npariso]

Hi @Rajesh is this what you are looking for?

[geraldo]

@Rajesh 

In your result there is something strange. Why the repetition of this value that is in the print?

[Rajesh]

@npariso apologies, if it wasn't clear from my side. trying to give more in detail. Thanks, in advance!

Lookup TB Date to TR date and in result it should give all lines from TR-Input file-2 where Date is higher than Date in TB- input file 1.

if you see in the result i want, it did not pick the 5/23/2023 as per the condition.

Input file 1
TB
Date	Balance
5/24/2023	212
5/24/2023	12
5/24/2023	331
5/24/2023	212
5/24/2023	212
5/24/2023	212

Input file 2
TR
Date	Balance
5/25/2023	545
5/25/2023	3535
5/25/2023	3535
5/25/2023	545
5/23/2023	545
5/23/2023	545

Result-TR
Date	Balance
5/25/2023	545
5/25/2023	3535
5/25/2023	3535
5/25/2023	545