I am trying to automate a process where the "Date of Last Payment" is identified from a loan amortization schedule. For example:

The column coordinate will always come from the "Date" column (B); the row coordinate needs to be determined based on the "Balance" column (C) - the final row where cell value is greater than zero - in this case, row 13. Therefore, the "Date of Last Payment" will be "Oct-14" (C2 = B13).

Screen Shot 2014-01-22 at 11.25.37 AM.png

I am going to be analyzing large groups of amortization schedules and I want to populate a summary sheet with the "Date of Last Payment" with the press of a button. There are numerous other factors but this is the only piece I haven't been able to figure out because of the variability and column relationships.
*Note that the "balance" column is a set of formulas.

Thanks in advance!