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

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

see one answer in microsoft.public.excel.newusers

Please don't post the same message in multiple groups. It only tends to
fragment any answers you get, and potentially wastes the time of those
posting solutions to questions that have already been answered.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm



In article ,
bertiesmum
wrote:

I need to write a 2 Vlookup formulas at Cell E25 to display the date aloan
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 specifiedthat he
wants lookups.
TIA Chris--
bertiesmum--------------------------------------------------------------------
----bertiesmum's Profile:
http://www.excelforum.com/member.php...erid=25989View this
thread: http://www.excelforum.com/showthread...hreadid=393528