Attached is a sample workbook for tracking monthly credit card payments and resultant balances in the MM YY sheets. The Payoff sheet summarizes end-of-month balances for each card assuming a fixed monthly payment. I want to simply show the month the card is expected to be paid off (as shown in the gray highlighted section). Not sure how to approach this kind of problem.... Ideally, I'd like to simply increment a VLOOKUP function through each sheet listed in Payoff:B3:B7, searching for the sheet where the New Balance =<0, then returning the name of the sheet. Is there any way to do this? Or is there a more appropriate approach?
Bookmarks