What is XLOOKUP?
The modern replacement for VLOOKUP and HLOOKUP with enhanced flexibility. XLOOKUP can search in any direction, return multiple columns, and includes built-in error handling.
Syntax
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
Example
Formula: =XLOOKUP(E2, A2:A100, B2:B100, \
Result: Value from B column
How It Works
XLOOKUP searches for a value in lookup_array and returns the corresponding value from return_array. Unlike VLOOKUP, it can look left, doesn't require column index numbers, and has built-in error handling with if_not_found parameter.