There's a simpler way to get the right price, and it doesn't require a helper column or a PhD in Excel logic. The user's frustration is entirely understandable: INDEX-MATCH is a powerful tool, but it's built for single-criteria lookups. When you ask it to find "Apple" and it sees Apple-East first, it stops. That's not a bug; it's the function doing exactly what it was designed to do. The real problem is that the tool itself hasn't kept pace with how people actually need to use their data.
The workarounds described, helper columns, nested MATCH attempts, even XLOOKUP, all point to a deeper limitation. A helper column that concatenates "AppleWest" works, but it adds clutter and breaks if your data changes. Nested MATCH with array logic can work, but it's brittle and hard to audit. XLOOKUP, for all its improvements, still defaults to the first match unless you explicitly configure it for multiple criteria with a concatenated lookup array. Every one of these solutions asks you to adapt your workflow to the spreadsheet, rather than the other way around.
What this user needs is a tool that understands relationships, not just rows. When you say "I want the price where Product is Apple and Region is West," you're describing a logical intersection, not a sequential search. An AI-native spreadsheet doesn't force you to translate that intent into a convoluted formula. It lets you express the condition naturally, whether through a simple syntax like `FILTER(C2:C5, (A2:A5="Apple")*(B2:B5="West"))` or through a guided interface that builds the logic for you. The result is the same: you get 12, not 10, and you don't have to wonder why your lookup broke when a new row appeared.
The lesson here isn't that INDEX-MATCH is bad. It's that the spreadsheet paradigm of "first match wins" was designed for a world where data was simpler and smaller. Today, your datasets have multiple dimensions, and your time is better spent analyzing results than debugging lookups. Stop guessing why your formula returns the wrong value. Use a tool that treats multiple criteria as a standard feature, not a workaround.