Excel VLOOKUP is loved by many users.
This leads to other professional to hear about VLOOKUP and started to learn more about it.
May of these VLOOKUP newbie have a good time learning this function, on the other hand...
Many others find the function terms difficult to grasp.
They are asking if learning this function is worth their time and effort.
Here I will show you 7 practical uses you can give to this awesome Excel function

1. Compare tables.
   When you have two tables: a master table and an update table, you can search if any value from the update table is on the master table
2. Reconciliation.
   Using the same method above you can find any discrepancies between two, three or more tables
3. Translate scores to grade letters.
   You can use VLOOKUP approximate match to translate score 95 into As, score 15 into Fs, etc
4. Find Phone, Price, and any other attribute of any given Product, Name, etc
5. Create a form where people use drop down lists to retrieve contact data, product data, etc
6. Merge tables.
   When you have more than one table and all of them contain data that need to be added, you can identify those entries that are missing and add them to the master table
7. Create a dashboard that retrieves data from different worksheets or workbooks

Conclusion.
Don't hesitate to fully grasp this function, the benefits could be one of the seven outlined above.
With practice you will find more practical applications of Excel VLOOKUP.
If you find them, please share them with us at the comment section of this article.