Help with vlookup in Excel 2003

[Guest]

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

 

[Anne Troy]

Hi, Chris. Try these articles if you're having difficulty with vlookup. The
first one, in particular, tells you how to do a vlookup and gives potential
reasons why a vlookup doesn't work. The second is a vlookup tutorial.
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com

 

[Debra Dalgleish]

Bosses don't usually care what formula you use, as long as the results
are correct.

There's information and examples for VLookup in Excel's Help, and more
examples here:

http://www.contextures.com/xlFunctions02.html

http://www.contextures.com/xlOrderForm01.html

 

[Guest]

Thank you for sending me the links Anne, thanks to your and Debra's replies,
I have the solutiion already, of course it was just a simple error and I was
complicating it. I do appreciate your time. Regards Chris.

 

[Guest]

Thank you for sending me the links Debra, thanks to your and Anne's's
replies, I have the solutiion already, of course it was just a simple error
and I was complicating it. My boss is strange like that but he wants
everybody to do things the same way - HIS! - lol. I do appreciate you taking
the time to help me. Regards Chris.