Loook up

Copper Contributor

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


I have a list with some date data as follows:




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:



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