learn microsoft excel

Vlookup in Excel 2007

Home
Excel 2003
Macros Excel 2007
Macros Excel 2003
Excel 2010
About Us
Free Ebook
Offline Training
Blog
books


Vlookup in Excel searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find. There are many ways to implement the function but the easiest way is explaineded below.
Essentially Vlookup works exactly the same way when we wish to lookup somebody's phone number from a directory. We search for a name which is almost always on the left-hand side. Then we move our finger to the right ensuring that we are in the same line (row) and pinpoint the phone number and almost immediately try to remember the number or dial the person while we have our finger on the number. Isn't it?

The MS Excel training video demonstrates Vlookup.


More Videos on Vlookup
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
About Us Free Ebook Offline Training Blog books