Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
A retail analyst's regional pricing lookup is returning plausible-looking but consistently wrong prices. They wrote:
=INDEX($A$1:$E$6, MATCH(G2, $A$2:$A$6, 0), MATCH(H2, $B$1:$E$1, 0))
It compiles. It returns numbers in the right ballpark. But for East × Tool (which should be 7.50) the formula returns 17.50 — South's Gadget price. Every output is shifted up one row and left one column.
The bug: the INDEX range is $A$1:$E$6 (the full grid including the header row and the label column), but the MATCH ranges are $A$2:$A$6 and $B$1:$E$1 (label-only). MATCH returns positions 1–5 / 1–4 inside its scoped range, so position 1 ("North") feeds into INDEX as row 1 of A1:E6 — which is the header row, not North's data row. Same off-by-one happens on the column axis.
Two valid fixes:
$B$2:$E$6. Now MATCH's positions and INDEX's coordinates are in the same frame.MATCH(G2, $A$1:$A$6, 0) and MATCH(H2, $A$1:$E$1, 0). Both axes now start at 1 from the same origin.Reference grid is at A1:E6 (already on the sheet). Three lookup pairs are pre-populated in G2:H4.
Your task:
Graded cells: I2, I3, I4.