In this Excel video tutorial, we gonna see how to use Xlookup formula in Google Sheets. Xlookup Function.

Through a practical example of how to use the Xlookup function, let's learn how to use this formula, which is one of the most important formulas in Google Sheets.

The XLOOKUP function in Google Sheets or Excel, we can interchangeable use it as the vlookup or as the hlookup or even as index match function.

The XLOOKUP formula 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 XLOOKUP function 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.

#JopaExcel #Dashboard #Excel