Loading…
Loading…
XMATCH is the modern MATCH: it is exact by default (no trailing 0 to forget), can find the next larger or smaller item without sorting, can search from the bottom, and supports wildcards. Pair it with INDEX for a lookup that works in any direction: INDEX(return_range, XMATCH(value, lookup_range)).
Syntax
XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
Example: =INDEX(C2:C6,XMATCH("Monitor",B2:B6)) returns the price of Monitor.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.