Formula X-RayExcel & Google Sheets, X-rayed
See exactly how every formula thinks.
Short tutorials that slow a formula down and show every step Excel takes to get the answer. Watch it evaluate, then try it yourself with a free practice file.
fx=XLOOKUP(1,(A2:A9=F2)*(B2:B9=G2),C2:C9)
How it works
- Pick a real problem. Lookups with two conditions, a stubborn #VALUE! error, sums between two dates.
- X-ray the formula. Each part is evaluated on screen, cell by cell, so you see why it works, not just that it does.
- Practice. Every video has a free spreadsheet with the same data, an empty answer cell and the solution on a second sheet.
Latest practice files
- Fix It Fast
XLOOKUP with Multiple Criteria (and How It Actually Works)
Look up a value that matches two conditions with one XLOOKUP formula.