🔎 Modern XLOOKUP

Goal: Find Price (Right) OR Find ID (Left).
XLOOKUP can search in any direction and handles errors natively.

Ready...

💻 Formula Structure

=XLOOKUP(lookup, lookup_array, return_array, [not_found])
  • 1. Lookup Value: What you are searching for.
  • 2. Lookup Array: The specific column to SEARCH in.
  • 3. Return Array: The specific column to RETURN from.
  • 4. Not Found: Text to show if missing (Optional).
-- Select a scenario...
=XLOOKUP( ... )
Final Result:
-

⚠️ Common Pitfalls

🚫 Array Size Mismatch
The Lookup Array (e.g., A2:A100) and Return Array (e.g., B2:B100) MUST be the same height.
✅ Fix: Check your ranges match exactly.
🚫 Selecting Whole Table
Unlike VLOOKUP, you select two separate columns, not the whole table.
✅ Fix: Select only the specific columns you need.