Set cell equal to variable cell (from set column) based on cells in adjacent column

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!

This may not be the most efficient way to solve the issue but I did the following:

Please Login or Register  to view this content.

The data included in the attached spreadsheet is incomplete but it is enough to illustrate how the task was accomplished. Let me know if there are any suggestions for improving it. Exploring Debt Calcs.xlsm

Thanks to Pauleyb for the suggestion.