Multi-column match
Match by Two Columns: SKU and Warehouse
Noah, an ecommerce analyst, matches order rows by SKU plus Warehouse so the right regional product cost is added.
Problem
Noah prepares a margin report every Monday. The same SKU can have different costs in different warehouses, so matching by SKU alone would produce the wrong margin. He uses two matching columns together: SKU and Warehouse.
Demo Files
Main file: Store Orders
| Order ID | SKU | Warehouse | Quantity | Sale Price |
|---|---|---|---|---|
| S-501 | A-100 | West | 2 | $39 |
| S-502 | A-100 | East | 1 | $42 |
| S-503 | B-245 | West | 1 | $120 |
Lookup file: Warehouse Product Costs
| SKU | Warehouse | Product Name | Category | Cost |
|---|---|---|---|---|
| A-100 | West | Desk Lamp | Home | $18 |
| A-100 | East | Desk Lamp | Home | $21 |
| B-245 | West | Carry Bag | Travel | $62 |
Recommended Options
- Trim extra spaces because exported SKUs often contain accidental whitespace.
- Treat numbers and text as the same when SKUs may include leading zeros.
Result Preview
Result preview
| Order ID | SKU | Warehouse | Quantity | Sale Price | Product Name | Category | Cost |
|---|---|---|---|---|---|---|---|
| S-501 | A-100 | West | 2 | $39 | Desk Lamp | Home | $18 |
| S-502 | A-100 | East | 1 | $42 | Desk Lamp | Home | $21 |
| S-503 | B-245 | West | 1 | $120 | Carry Bag | Travel | $62 |
What This Shows
- Multi-column matching prevents false matches when one key is not unique enough.
- Noah gets the correct regional product cost, which makes the margin report more reliable.
Related searches
vlookup multiple criteriamatch orders by sku and warehousemerge product catalog with orders
Need VLOOKUP with multiple criteria?
This example uses SKU + Warehouse as two matching criteria. See the dedicated guide and try a sample workflow built for multi-column matching.
Open multiple criteria guideTry the same setup in SheetMatch
Upload your main file and lookup file, choose the matching columns shown above, then select the columns you want to bring into the result.
Open SheetMatch