Hi:

Have a large data base of leases that I need to do proration calculations of prepaid lease by MONTH of closing. I'm attempting to grab the 'Earned Lease' for the closing month and then blank out the remainder months to determine the year total.

I've marked up the spreadsheet attached for help and I've tried multiple ways to no avail.

Appreciate any help.

thanks
Index Match with Calculation.xlsx