Excel Vlookup Tutorial

Excel Vlookup Function A Real Life Example
In the video below I provide a tutorial on how to use the Excel Lookup.  I also provide hints on common mistakes/problems using the function.

FunctionLooks for a value in the leftmost column of a table and then returns a value in the same row from a column you specify. By default the table must be sorted in ascending order.
VLOOKUP(Lookup value,  table array,  col_index_ num.  exact  match?)

Lookup Value
Table Array
Col Index
Exact Match?
This is the value you are looking up This is the table you are looking the value up in This is the table column number of the values you want returned Exact match = false  approximate match = true
Below I’ve provided a video VLookup Function A Real-Life Example
1. The table containing the data you are looking to should have the leftmost column (you will be using) sorted in ascending order – In the video that is Column A on the sheet on the right.
2. Make sure the item you are looking up and the column you are looking it up in are the same field types, e.g., numbers, text etc.
3. Sometimes data extracted from systems include extra spaces, zeros, etc.  Pay attention and give all data a good look over!
If you were able to utilize what you learned here or improve the code, 

please leave a comment Here

If you enjoyed this post or found it helpful andl would like to say hello and
buy me a cup of coffee Click here

Raymond Mills MBA, MS
Raymond Mills, M.B.A., M.S.  has spent over 20 years of his career as Accountant, Investment Bank and Credit Card Technical Auditor/ Data Analyst.  His specialty was using Excel to get Big Databases including Teradata, Oracle,  Squel Server and Sybase to give up their secrets. Ray has said “I love nothing better than using VBA to unleash the power of Microsoft Office.” You can contact Ray @ 484 574-3190 or by emailing him Here

If you have a challenge with Excel, Access or Word and would like to speak with Ray,   You can get his contact details by clicking here: Contact Me

Comments are closed.