XLOOKUP is a function that allows you to search for a value in a table or range and return a corresponding result from a different column in the same row. It is similar to the VLOOKUP and HLOOKUP functions but has additional features and capabilities.
One of the key advantages of XLOOKUP is that it can perform searches in any direction, whereas VLOOKUP can only search from left to right. It can also support wildcards.
The syntax for the XLOOKUP function is as follows:
=XLOOKUP(lookup_value, lookup_array, return_array, [match_mode], [search_mode])
- lookup_value: the value you want to find in the lookup_array
- lookup_array: the range of cells where you want to search for the lookup_value
- return_array: the range of cells containing the results you want to return
- match_mode: an optional argument that determines the type of match to perform. It can be "0" for an exact match, "1" for an approximate match, or "-1" for a wildcard match
- search_mode: an optional argument that determines the direction of the search. It can be "1" for a search from top to bottom or left to right, or "-1" for a search from bottom to top or right to left
XLOOKUP is a powerful tool for data analysis and can save a lot of time and effort when working with large data sets in Excel.
More information can be found on the Microsoft website.