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 Match Tutorials
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.
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.
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.