Loook up

Occasional Visitor

Hi Friends, I want some help with a difficult issue for me.

 

I have a list with some date data as follows:

 

 

List1:

Payment 1: 22/01/2022

Payment 2: 24/02/2022

 

And I have another list with the payroll date, What I want is to create another column with the payment date:

 

ListPayroll:

Day: 22/01/2022

PaymentDay: 03/02/2022

 

I think the best way is a kind of look up value with the Payment1 and Day, then the result is the PaymentDay.

 

Thank you, nice day!

0 Replies