Payoff Dates and Final Payments

Hello,

I have amortization schedules for 2 loan scenarios. I would like the Payoff Dates and Final Payments for each of the 2 loan scenarios that I highlighted in orange on the 'Inputs' sheet. These come from the other 2 sheets but aren't always from the same cells. The Input sheet allows you to change amounts is why.

Does anyone know how to have the orange cells filled in please?

Thank you

I used the MAX function to retrieve the latest dates and then index match to get the amounts.

Thanks