In this Excel free tutorial, we gonna see how to use vlookup function and the xlookup function in Excel. And, why should you choose, in some cases, to use xlookup over vlookup in Excel.

The XLOOKUP function can be used to find things in a table or range by row.

For example, if you want to look up the price of an automotive part by the part number or even find an employee name based on their employee ID.

You can use the XLOOKUP function to help you out to automate this task.

You can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

The VLOOKUP function in Excel can be used when you need to find things in a dataset, in a table or in a range by row.

So, for example, we want to look up a price of an automotive part by the part number or even find an employee name based on their employee ID.

However, the vlookup function have a major flaw, with your reference column, I mean, the column you need to use as the reference for the lookup function is to the right of the column you need the result from, you are screwed. Because, the vlookup function in this situation, can not return any result.

So this is way, the xlookup is a better option to choose, or you can even choose for the index match function in Excel.

#JopaExcel #Dashboard #Excel