How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Vlookup Tutorials
This tutorial teaches you how to insert the Vlookup function in Excel.
The Vlookup function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column of the table.
Use the VLOOKUP Function Across Multiple Tables
Although VLOOKUP itself is very handy, it is restricted to looking in a specified table to return a result, which sometimes is not enough. You can escape this limitation with the INDIRECT function.
VLOOKUP in excel stands for vertical lookup. This simple function is extremely useful if you have large lists of data. With this function, you can easily search through a list of data and match specific criteria. I
How to use Vlookup function
Illustration of how vlookup helps to match values in Excel.
VLOOKUP Function Example
Brief summary of the VLOOKUP function and how to use it
Using the Vlookup Function in Excel
Tutorial videos for self learning the vlookup function, whether using it for finding an exact match in a table, or a close match.
Merging two Excel files using VLOOKUP function
Merging two Excel files using VLOOKUP function is very powerful and convenient for Data Analysis when manual matching of two files is very time consuming because of size of data.
Learn how to use the VLOOKUP function in Excel
As useful as the VLOOKUP function is, there is a significant risk of errors. Learn what you must watch for.
VLOOKUP with large tables of information
Once you have mastered VLOOKUP you may find that you use it for large datasets. The problem is that when you make changes to your spreadsheet you sometimes need to go through all the VLOOKUP cells and change the column reference. Learn how to avoid this!