Eliminating an unnecessary column

[BigPapaMurf]

I've got an amortization table much, like any other one, but I've got a formula to provide me the outstanding balance. The only way i've seemed to get it to work is if i add a column, referencing the previous rows balance. How can I eliminate that requirement in the following sample spreadsheet.


=IFERROR(INDEX(C2:C14,MATCH(TRUE,A2:A13>TODAY(),0)),"")

Column A = date,
Column C = Column B-1 row

I want to eliminate Column C

[Bo_Ry]

Please try

=IFERROR(INDEX(--B1:B12,MATCH(TRUE,A2:A13>TODAY(),0)),"")

[BigPapaMurf]

While the formula does allow me to eliminate column C, It's given me the wrong row result. Also note, I provided a bad sample where the rows did not line up. My fault. A more accurate sample is now attached in this reply message.
The outstanding balance should = the value in column K where the date in column B is the last date to have passed. So, using the formula you provided and my slight range adjustment, As of today 5/31, the outstanding balance should = cell K21 and not K22.

See the new attachment. I also moved the sample data to the actual cells they are in on my spreadsheet

[BigPapaMurf]

I think I just figured it out.....
I added a -1 after the TODAY(),0)
so it looks like this, based on your example and my slight range correction

=IFERROR(INDEX(--B2:B13,MATCH(TRUE,A2:A13>TODAY(),0)-1),"")

[BigPapaMurf]

Thanks for your help Bo_Ry. Considering the issue solved.