Help with VLookup in Excel 2003 please

[bertiesmum]

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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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

[Bill Kuunders]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JE McGimpsey]

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 <[email protected]>,
bertiesmum <[email protected]>
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