In this Excel video tutorial, we gonna se how to Xlookup in Excel with All the Arguments Explained, If Not Found, Match Mode, Search Mode etc.

Through many different practical examples of how to use the Xlookup function in Excel, let's learn how to use this formula, which is one of the most important formulas in Excel, step by step in addition to seeing all the arguments of this function here in Excel.

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

The Excel 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 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.

#JopaExcel #Dashboard #Excel