Vlookup is one of the important  function is excel sheet. Mastering in it will be a beneficiary in your accounting or financial field. 

It can be use in following way: 

Create Relationships Between Data and Lookup Tables 

Search Tables and Databases 

Interactive Reports and Financial Models

Tax and Commission Rate Calculations


Writing a Vlookup formula.


Common errors you will encounter. 

match Vlookup is another key points one  need to work on


Source: https://www.youtube.com/watch?v=d3BYVQ6xIE4 (Excel Campus-Jon, 2019)