Subscribe
Tutorial search

Excel Match Tutorials


Sort by:
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:
MATCH function
MATCH function
Shows how to use the MATCH function in Excel to find where in a group of cells a certain cell exists. Useful in conjuction with VLOOKUP.
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:
Search Term(s) (1): match