Forum Discussion
Excel Formula Help: Reflecting Dynamic Monthly Credit Card Payments by Date
The Goal: To display the correct monthly payment amount (from the Debt Schedule tab) on the Main Worksheet tab, placing each payment under the correct date column (J4:AV4) based on the due date for ...
Your Google Sheet link requires sign-in, I don’t have a google account
....but you can put this formula in the Main Worksheet where the row = card and column = month:
= XLOOKUP($A6,
'Debt Schedule'!$A:$A,
XLOOKUP(J$4,
'Debt Schedule'!$1:$1,
'Debt Schedule'!$A:ZZ,0),0)
Make sure your header row (J4:AV4) contains real Excel dates (not text).
Your Debt Schedule month headers should also be real Excel dates.
Hope this helps you.