← Back to level 2
Level 2Level 2
XLOOKUP
A flexible lookup function that replaces many older lookup patterns.
Syntax
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])Step-by-step explanation
- 1Select the lookup range and the return range separately.
- 2Handle missing values with if_not_found for a better experience.
- 3Use it for cleaner and more reliable lookups than VLOOKUP.
Common mistakes
Mixing lookup and return ranges
Forgetting it is not available in older Excel versions
Leaving if_not_found blank when handling errors matters
Example table
A quick scenario to connect the syntax to the result.
| East | 120 |
| West | 155 |
Formula
=XLOOKUP("West",A1:A2,B1:B2)
Result
155
Practice area
Find the value for the West region.
Match against the syntax block above.