XMATCH is a modern version of MATCH with additional matching and search options.
Syntax
=XMATCH(lookup_value,lookup_array,[match_mode],[search_mode])
Example:
=XMATCH(“Rahul”,B2:B4)
Result: 3
Common Match Modes
|
Match Mode |
Meaning |
|
0 |
Exact match |
|
-1 |
Exact or next smaller item |
|
1 |
Exact or next larger item |
|
2 |
Wildcard match |
Practice
Use XMATCH to find:
- Employee position
- Product position
- Student position