XLOOKUP & INDEX MATCH Multiple Criteria Generator
Compare exact syntax for XLOOKUP multiple criteria, INDEX MATCH multiple criteria, and SUMIFS between two dates — or combine keys visually and join sheets below with zero formula errors.
=XLOOKUP(A2&"|"&B2, Order_Owners!$A$2:$A$200&"|"&Order_Owners!$B$2:$B$200, Order_Owners!D2:D200, "Not Found")Drop XLSX, CSV, TSV, Markdown (.md), or JSON here
Runs locally inside browser memory. Multi-sheet workbooks open into tabs automatically.
Combine Two or More Columns
Merge 2+ columns cleanly without writing formulas.
Split Column by Delimiter
Remove Duplicate Rows
Find & Replace
Sort Rows
Filter or Delete Matching Rows
Fill, Prefix / Suffix & Extract Column
Merge Multiple Files / VLOOKUP Join Sheets
Append rows from multiple files/tabs or join two sheets by a key column.
Option A: Stack / Append All Open Sheet Tabs
Option B: VLOOKUP / Left-Join Two Sheets by Key
Format Preview & Export Converter
Column Profiler & Quick Summary
| Col | Header | Filled | Blank | Unique | Dupes | Min / Max / Avg |
|---|
Paste CSV, TSV, Markdown Table, JSON, or HTML
Confirm Action
Frequently Asked Questions
How does XLOOKUP with multiple criteria work in Excel and Google Sheets?
Concatenate your criteria cells and lookup columns with a safe separator inside XLOOKUP: =XLOOKUP(A2&"|"&B2, Sheet2!$A$2:$A$100&"|"&Sheet2!$B$2:$B$100, Sheet2!$C$2:$C$100, "Not Found"). Both Excel 365 and Google Sheets evaluate concatenated array ranges without helper columns.
How do I run INDEX MATCH with multiple criteria if my company uses older Excel?
Multiply boolean conditions inside MATCH: =INDEX(Sheet2!$C$2:$C$100, MATCH(1, (Sheet2!$A$2:$A$100=A2)*(Sheet2!$B$2:$B$100=B2), 0)). Note: press Ctrl+Shift+Enter in Excel 2019 or earlier.
What is the syntax for SUMIFS between two dates in Excel?
Repeat the date column twice with ">=" and "<=" operators: =SUMIFS(AmountRange, DateRange, ">="&StartDateCell, DateRange, "<="&EndDateCell).
