4.8 XMATCH
Microsoft 365 / Excel 2021+. =XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) – like MATCH, but exact match by default and with the same modes as XLOOKUP.
| Formula | Result |
|---|---|
=XMATCH("Oct", CityMonth!$B$1:$E$1) |
3 |
=XMATCH("Nagpur", CityMonth!$A$2:$A$5) |
3 |
=INDEX(CityMonth!$B$2:$E$5, XMATCH(H1,CityMonth!$A$2:$A$5), XMATCH(H2,CityMonth!$B$1:$E$1)) |
Two-way lookup |
=XMATCH(MAX(G2:G11), G2:G11) |
Row position of the biggest order |
Ravindra Bagale's Tip
MATCH madhun XMATCH la jaatana khup students jun ya savayine shevti 0 lihitat – XMATCH madhe 0 exact ch aahe, tyamule chalta. Pan MATCH madhe 0 visarla tar approximate hota, XMATCH madhe nahi. Office madhe mixed versions astil tar MATCH(…,0) ch vapra – sagalikade chalto.
Practice task
Use XMATCH to find the position of "Kolhapur" and "Nov" in the CityMonth table, then combine with INDEX.