🧩 The Power Pair

Goal: Find the Price for "Product C".
MATCH: Finds the row number (GPS).
INDEX: Retrieves the value at that number (Grabber).

Ready...

💻 Formula Structure

=INDEX(return_range, MATCH(lookup_val, lookup_range, 0))
  • 1. Return Range: The column containing the answers (Prices).
  • 2. Match Value: What you are looking for ("Product C").
  • 3. Lookup Range: Where to search (Product Names).
  • 4. 0: Exact Match (Crucial!).
-- Step 1: Find Position
=MATCH( "Product C", B2:B5, 0 )

-- Step 2: Get Value at Position
=INDEX( C2:C5, 3 )
Final Result:
-

⚠️ Common Pitfalls

🚫 Mismatched Heights
If your Index range is A2:A100 but your Match range is B2:B101, the results will be misaligned.
✅ Fix: Ensure both ranges start and end at the same row.
🚫 Missing "0" in MATCH
MATCH defaults to "Approximate" (1). If data isn't sorted, this returns wrong data.
✅ Fix: Always use 0 for exact match.