Does 2003 excel have training on V Lookup

[Matt Franc]

Went through the training portion of excel and could not find training for
Vertical (vlookup) look up. Did I miss it or is it not there?


Thanks

 

[Anne Troy]

I didn't know there WAS a training portion. Perhaps it was something the
manufacturer installed on your PC. See if this helps:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm

Or perhaps this tutorial will help you with Vlookup:
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[Alan]

Yes it is, enter VLOOKUP in the Help bit and its there,
Basically a VLOOKUP formula like
=VLOOKUP(A1,C1:F250,2,FALSE)
=VLOOKUP(What to look for,Where to look for it,Which column to return,Find
exact match or nearest match)

 

[Matt Franc]

this is not a training seminar but it will work, thanks a bunch

 

[Matt Franc]

Thanks.. very helpful

I didn't know there WAS a training portion. Perhaps it was something the
manufacturer installed on your PC. See if this helps:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm

Or perhaps this tutorial will help you with Vlookup:
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com