Practice file · Fix It Fast

XLOOKUP with Multiple Criteria (and How It Actually Works)

Look up a value that matches two conditions with one XLOOKUP formula, and see step by step how Excel evaluates it.

Download the Excel file
Video coming soon

Your task

  1. Open the file. The Practice sheet has the data and an empty answer cell.
  2. Find the price of Tea in the North with one XLOOKUP formula in H2.
  3. Check yourself. The Answer sheet has the working formula.
Show the answer
fx=XLOOKUP(1,(A2:A9=F2)*(B2:B9=G2),C2:C9)