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