Excel Tutorial – XLOOKUP

The XLOOKUP function in Excel allows you to search for a value in a table and return a value from the same row based on a specified column number or column name. This can be useful if you have a large table of data and you want to quickly retrieve a specific value within that table.

To use the XLOOKUP function, you will need to follow these steps:

1. Select the cell where you want the result of the XLOOKUP function to appear.
2. Type “=XLOOKUP(” (without the quotes) into the cell.
3. Specify the value that you want to search for in the table. This should be a number or a string of text enclosed in quotation marks.
4. Type a comma and then specify the range of cells that contains the table that you want to search.
5. Type a comma and then specify the column number or column name of the value that you want to retrieve. If you specify a column number, the first column in the table is considered column 1. If you specify a column name, it should be enclosed in quotation marks.
6. Type a comma and then specify whether the search should be performed in a case-sensitive manner. If the search should be case-sensitive, set this parameter to TRUE. If the search should not be case-sensitive, set this parameter to FALSE.
7. Optional: You can specify an additional parameter to specify the default value to return if the search value is not found in the table. This can be a number, a string of text enclosed in quotation marks, or a reference to a cell.
8. Close the parenthesis by typing “)”.

For example, if you wanted to search for the value “apple” in the table A1:C3 and return the value in the third column of the same row, you could use the following formula: “=XLOOKUP(“apple”, A1:C3, 3, FALSE)”. This will return the value in the third column of the same row as “apple” if “apple” is found in the table A1:C3.

I hope this tutorial has been helpful in understanding how to use the XLOOKUP function in Excel.