XLOOKUP with Multiple Criteria — One Formula, No Helper Columns (2026)
XLOOKUP with multiple criteria — how to do a two-condition lookup in Excel and Google Sheets with ONE formula and NO helper column. Learn the 2026 boolean-multiply method =XLOOKUP(1,(a=x)*(b=y),ret), why looking up the number 1 works, and the one time you should NOT use it.
⬇️ FREE WORKBOOK (both methods + a 3-condition example):
https://sheetlark.gumroad.com/l/xlookup-mu...
You'll learn:
• How to look up a value that needs TWO conditions true at once — no helper column
• The 2026 boolean-multiply method, and why the number 1 works
• Adding a clean "Not found" fallback
• The concatenation alternative
• When NOT to use it (big datasets, duplicate combinations, unequal ranges)
• How to extend the pattern to three or more conditions
Works in Excel (365 / 2021+), Google Sheets, and LibreOffice Calc 24.8+.
Chapters:
0:00 Intro
0:23 The problem
0:50 The helper-column trap
1:19 The one-formula fix
1:44 Why the number 1?
2:23 Prove it works
2:46 Return any column
3:09 When NOT to use it
3:57 Concatenation variation
4:31 Clean no-match handling
4:55 Scale to 3+ conditions
5:19 Recap + free file
🔔 Subscribe to Sheetlark — one spreadsheet fix at a time.
#Excel #XLOOKUP #GoogleSheets #Spreadsheets #ExcelTips