ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Does 2003 excel have training on V Lookup (https://www.excelbanter.com/excel-worksheet-functions/47663-does-2003-excel-have-training-v-lookup.html)

Matt Franc

Does 2003 excel have training on V Lookup
 
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/...soft_excel.htm

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

"Matt Franc" <Matt wrote in message
...
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




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" <Matt wrote in message
...
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




Matt Franc

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

"Alan" wrote:

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" <Matt wrote in message
...
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





Matt Franc

Thanks.. very helpful

"Anne Troy" wrote:

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/...soft_excel.htm

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

"Matt Franc" <Matt wrote in message
...
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






All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com