Orders and account managers
Bring account manager and region into an order export when the same customer has multiple dates.
Match by Customer ID + Order Date
VLOOKUP with Multiple Criteria Online
Match rows by two or more columns, such as Customer ID + Order Date, Email + Date, or SKU + Warehouse. No helper columns or formulas required.
1
Upload Main Table
Upload file
XLSX or CSV, max 10MB / 50,000 rows
Paste a table
2
Upload Lookup Table
Add the main table first.
Your spreadsheets are processed locally in your browser. We do not upload or store your files.
How VLOOKUP with multiple criteria works
A normal VLOOKUP usually matches one value, such as an email address or order ID. Multiple criteria means the row must match two or more columns at the same time. For example, Customer ID plus Order Date can identify the right lookup row more precisely than either column alone.
In SheetMatch, you do not need to build a helper column or write nested formulas. Upload or paste two tables, choose each matching column pair, then select the values you want to bring back.
Common criteria pairs
- Customer ID + Order Date
- Email + Event Date
- SKU + Warehouse
- Invoice Number + Amount
Examples
Payments and invoices
Match payment records to invoices when invoice numbers can repeat across systems.
Match by Invoice Number + Amount
Inventory by location
Add product details to a stock list where the same SKU exists in more than one warehouse.
Match by SKU + Warehouse
Excel formula approach vs SheetMatch
| Excel formula | SheetMatch |
|---|---|
| Often requires a helper column that joins criteria together. | Select multiple matching column pairs directly. |
| Formula setup changes when your columns move. | Choose columns by name and Excel-style column letters. |
| Harder to review unmatched rows or duplicate lookup matches. | Preview results, handle duplicates, then copy or download the output. |
FAQ
Can VLOOKUP use multiple criteria?
Yes, but in Excel it usually requires a helper column or a more complex formula. SheetMatch lets you choose multiple matching column pairs directly.
Can I match more than two criteria?
SheetMatch currently supports one or two matching column pairs in this flow, which covers common cases like Customer ID plus Date or SKU plus Warehouse.
Do I need to create a helper column?
No. You can select each criterion as a separate column. SheetMatch combines the selected values internally when matching rows.
Can I use CSV files?
Yes. You can upload XLSX or CSV files, or paste table data copied from Excel, Google Sheets, Numbers, or another spreadsheet tool.
Are my files uploaded?
No. Spreadsheet parsing, matching, previewing, copying, and downloading happen locally in your browser.