Embedded Files
About XLOOKUP Function?
The XLOOKUP function searches a range for a value and returns a corresponding value from another range. Unlike VLOOKUP or HLOOKUP, it’s far more flexible and has become the preferred choice for many Excel users.
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
lookup_value: The value you want to find.
lookup_array: The range to search in.
return_array: The range from which to return a value.
if_not_found (optional): A value to return if no match is found.
match_mode (optional): Allows exact match, approximate match, or wildcard searches.
search_mode (optional): Controls whether to search from the start, end, or perform a binary search for sorted data.
Key Features
Exact Match by Default: Unlike VLOOKUP, which defaults to an approximate match, XLOOKUP defaults to an exact match, reducing errors.
Left Lookup: XLOOKUP can look to the left, unlike VLOOKUP, which only works with columns to the right.
Flexible Error Handling: You can set a custom message or value if the lookup fails using the if_not_found argument.
Google Sites
Report abuse