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:

Sub Macro2()
'
' Macro2 Macro

    Range("H7").Select
  ' Identify last cell in column with value greater than $0  
    ActiveCell.FormulaR1C1 = _
        "=SMALL(R[4]C[-1]:R[363]C[-1],COUNTIF(R[4]C[-1]:R[363]C[-1],""<=0"")+1)"
  ' Lookup the date of last payment  
    Range("G7").Select
    ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[1],R[4]C:R[363]C[5],6,FALSE)"
  ' Copy/Paste Value to delete formula 
    ' I did this because I needed to be able to change inputs without impacting this date.  
    Range("G7").Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
  ' Delete the vlookup formula
    ' I did this because it was no longer necessary after inputting new data  
    Range("H7").Select
    Application.CutCopyMode = False
    Selection.ClearContents

End Sub

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.