An ops analyst's regional-sales 2D lookup uses the classic INDEX/MATCH/MATCH pattern:
=INDEX($B$2:$F$7, MATCH(H2, $A$2:$A$7, 0), MATCH(I2, $B$1:$F$1, 0))
It works. But the team is migrating to XMATCH — Excel's modernized MATCH that supports binary-search and wildcard match modes via a 4th argument, and (more practically) communicates intent better in code review. Default XMATCH is exact-match, so you can drop the trailing ,0 that MATCH requires.
The reference grid at A1:F7 is six locations × five product categories of unit sales. Three (location, category) pairs are pre-populated in H2:I4.
Your task:
- Refactor into a single formula in column J that uses INDEX with two XMATCH calls (one for the row, one for the column).
- Output values must match what the original INDEX/MATCH/MATCH would produce.
Graded cells: J2, J3, J4.
Open this problem on a desktop to attempt it.