Subscribe
Tutorial search

Excel Vlookup Tutorials


Sort by:
Excel Vlookup
Excel Vlookup
This tutorial teaches you how to insert the Vlookup function in Excel.
Difficulty:
Excel Vlookup
Excel Vlookup
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.
Difficulty:
Use the VLOOKUP Function Across Multiple Tables
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.
Difficulty:
Excel VLOOKUP
Excel VLOOKUP
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
Difficulty:
How to use Vlookup function
How to use Vlookup function
Illustration of how vlookup helps to match values in Excel.
Difficulty:
VLOOKUP Function Example
VLOOKUP Function Example
Brief summary of the VLOOKUP function and how to use it
Difficulty:
Using the Vlookup Function in Excel
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.
Difficulty:
Merging two Excel files using VLOOKUP function
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.
Difficulty:
VLOOKUP
VLOOKUP
Learn how to use the VLOOKUP function in Excel
Difficulty:
VLOOKUP Errors
VLOOKUP Errors
As useful as the VLOOKUP function is, there is a significant risk of errors. Learn what you must watch for.
Difficulty:
VLOOKUP with large tables of information
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!
Difficulty:
Search Term(s) (1): vlookup