Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
You're a strategy consultant pulling approved budgets from a master spreadsheet that's keyed by three columns at once: Customer × Product × Quarter. None of the three columns is unique on its own — every customer buys multiple products across multiple quarters — so a single-column INDEX/MATCH won't work.
Master at A2:D19: Customer, Product, Quarter, Approved Budget. Three lookups are pre-populated in F2:H4 (Customer, Product, Quarter).
Two valid INDEX/MATCH patterns for composite-key lookup:
=INDEX($D$2:$D$19, MATCH(1, ($A$2:$A$19=F2)*($B$2:$B$19=G2)*($C$2:$C$19=H2), 0)). The boolean array (=F2)*(=G2)*(=H2) is 1 only on the row where all three conditions match; MATCH finds the position of that 1.=INDEX($D$2:$D$19, MATCH(F2&"|"&G2&"|"&H2, $A$2:$A$19&"|"&$B$2:$B$19&"|"&$C$2:$C$19, 0)). Works in modern Excel without Ctrl+Shift+Enter; legacy Excel needs array entry.The boolean-AND pattern is more common in practice because it doesn't depend on a separator that might collide with real data.
Your task:
Graded cells: I2, I3, I4.