troubleshooting Question

In Excel I have data on leases payment amounts and payments dates. I need to show the amount of a payment in the correct row of payment date and in the column of the appropriate lease.

Avatar of Michael O'Flaherty
Michael O'FlahertyFlag for New Zealand asked on
SpreadsheetsMicrosoft ExcelMicrosoft Office
4 Comments1 Solution112 ViewsLast Modified:
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?

Saqib Husain

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros