In this Excel tutorial, we gonna learn what is the difference between VLookup, HLookup, XLookup functions in Excel, when should I use each of the functions, what is the best function to use etc.

We are going to use a practical example to help us understand how to use the VLookup function, HLookup function and XLookup function in Excel. From this practical example, we will be able to learn step by step the operation of each of the functions in the Excel spreadsheet.

Maybe, this function in Excel is one of the most important as it can help us automate repetitive tasks and automate repetitive processes.

The VLOOKUP function in Excle can be used when you need to find something in a table or a range. For example, look up a item price by the sku number or find an employee name based on their employee ID. Basically, the VLOOKUP function in Excel ask us, what you wanna look up and where you wanna look for it and what's the column number postion in the range that containing the value to return.

The Hlookup function in Excel almost works the same way as the vlookup, but the difference is in the way o search. The Hlookup function stands for horizontal look up, while the vlookup stands for vertical search for.

The Hlookup function can searches for a value that is alocate in the top row, and then returns a value in the same column that matchs with the look up value.

Now, with the XLOOKUP function in Excel, we can interchangeable use it as the vlookup or as the hlookup. It can cover the both previous functions.

#JopaExcel #Dashboard #Excel