J
jeff
Hi,
Because this formula (VLookup) can't refer to a value
on the left (ie, col = -1), you'll have to have a hidden
helper column on the right of your data that matches
your month/yrs. then this will work for you:
=VLOOKUP(0,B3:E18,4,FALSE)
(adjust B3:E18 to suite your needs: i assumed
colA=Mth/yr, B=prinbal, C=pmt, D=Xtra pmt, E=Mth/yr
jeff
Because this formula (VLookup) can't refer to a value
on the left (ie, col = -1), you'll have to have a hidden
helper column on the right of your data that matches
your month/yrs. then this will work for you:
=VLOOKUP(0,B3:E18,4,FALSE)
(adjust B3:E18 to suite your needs: i assumed
colA=Mth/yr, B=prinbal, C=pmt, D=Xtra pmt, E=Mth/yr
jeff