In this Excel video tutorial, we gonna see how to use Vlookup function in Excel to Match Columns and Rows or, in other words, how to use vlookup function in Excel with two criteria or how to use an Excel 3D Lookup Formula.

How to use the Vlookup formula in Excel coupled with the Match Function to solve a Practical Example and to Automate Tasks and Save Time.

The Vlookup function can be compared with the Hlookup function or the Xlookup or Index and Match function or Lookup. In other words, it is a search function, it is a search formula.

In my opinion, the Vlookup Formula is one of the best functions for automate tasks and save time on a daily basis, because instead of you searching for the item you need manually, this function formula can automate this task for you, automate the process.

The MATCH function can be used to searche for a specified item in a range of cells, and it returns the relative position of that item in the range. Let's say you want to know what's the column that has "abc123" as the header, you can use the match formula to return the postion number of this specific column.

#JopaExcel #Dashboard #Excel