VLOOKUP Multiple Criteria in Excel & Online
Standard VLOOKUP only checks one column. Generate an exact two-criteria formula below for Excel / Google Sheets, or run a formula-free composite key join right inside the live grid.
Fastest Way to Run VLOOKUP With Two Criteria:
In Excel 365 or Google Sheets, join both lookup values with a pipe character using=XLOOKUP(E2&"|"&F2, A2:A50&"|"&B2:B50, C2:C50, "Not Found"). For older Excel versions (2016/2019), concatenate a helper key column or merge directly online without formulas below.
Multi-Criteria Lookup Formula Generator
=XLOOKUP(A2&"|"&B2, Order_Owners!A2:A100&"|"&Order_Owners!B2:B100, Order_Owners!D2:D100, "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
How to Run Multi-Criteria Joins Without Formulas
- Open both workbook tabs above (or click + New Sheet and upload Sheet 2).
- Click Combine Columns on Tab 1 and join your 2 key columns (for example
Customer+State) with|. - Repeat on Tab 2 with the exact same column order and separator.
- Click Merge / Join, match both new key columns, and download a clean static
.xlsxor.csv.
Frequently Asked Questions
Can native Excel VLOOKUP match two or more criteria at once?
Not directly with a single column argument. To match multiple criteria in Excel, either concatenate a helper key column (=A2&"|"&B2) for VLOOKUP, use XLOOKUP with concatenated arrays (=XLOOKUP(E2&"|"&F2, A2:A50&"|"&B2:B50, C2:C50)), or combine key columns inside SheetCombine before clicking Merge / Join.
What is the cleanest delimiter for a multi-criteria lookup key?
Use a character that rarely appears inside your text, such as a pipe (|) or tilde (~). Joining keys without a delimiter (A2&B2) can accidentally collide ("AB"+"C" matches "A"+"BC").
How do I run multi-criteria VLOOKUP online without formulas?
Open both sheets as tabs below, click Combine Columns to merge your two match columns (such as Customer + State) on each sheet with a pipe separator, then run Merge / Join on that new composite key column.
