One way.....
rearrange the table a little so that the closing balance is the first column
in your table.
and date is the second column.
then to find the date where the closing balance = 0 use
=VLOOKUP(0,table,2,FALSE)
and for the cumulative interest (which is still in the last column),
=VLOOKUP(0,table,6,FALSE)

Greetings from New Zealand
Bill K

"bertiesmum" wrote
in message ...

I need to write a 2 Vlookup formulas at Cell E25 to display the date a
loan
will be repaid and secondly the total interest paid.
I have an analysis table called 'table' with 6 columns
1. Date
2. Opening loan balance
3. Add interest
4. Less payment
5. Closing balance
6. Cumulative interest
I can get the sheet to work easily but the vlookups are an entirely
different matter, I just cant get them to work. My boss has specified
that he
wants lookups.
TIA Chris


--
bertiesmum
------------------------------------------------------------------------
bertiesmum's Profile:
http://www.excelforum.com/member.php...o&userid=25989
View this thread: http://www.excelforum.com/showthread...hreadid=393528