I have an Excel sheet showing lease details for 20 leases.
The main details are the payment amount each quarter and the dates of those payments.
Below each lease I have rows for their payment date.
I want the amount of each lease's quarterly amount (in row 6) to be shown in the relevant row (from 1/1/2017 below row 32) and in the column of the respective lease.
The file is attached.
How do I achieve this?