Workflow · Clean · Opening soon

VLOOKUP between two sheets

Use exported Excel sheets to match each order row to product details. You can build the same lookup logic you would use in VLOOKUP, without formulas.

Book a demo

Someone typed

“look up each order's product price and category from the product sheet, like a vlookup”

The agent read it as

Look up each order's product price and category from the Products sheet for each Orders sheet, like a vlookup.

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

File

Orders sheet

CSV export · 18 rows

File

Products sheet

CSV export · 11 rows

Step

Make order SKU key

Step 1

Step

Make product SKU key

Step 2

Join

Look up product details

17 of 18 paired

Step

Show order details

Step 4

Result

Order Product Lookup

20 rows

Schedule

Runs when you say

Proposed

File
Orders sheet
CSV export · 18 rows
File
Products sheet
CSV export · 11 rows
Step
Make order SKU key
Step 1
Step
Make product SKU key
Step 2
Join
Look up product details
17 of 18 paired
Step
Show order details
Step 4
Result
Order Product Lookup
20 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 20 rows came out, and the join paired 17 of 18 rows.

Download Orders sheet sample (18 rows)Excel: open the workbook, click the Orders sheet, then copy the used range as a table
Download Products sheet sample (11 rows)Excel: open the workbook, click the Products sheet, then copy the used range as a table

What you get back

The result of that run, the rows to look at first.

Order Product LookupSample data20 rows

Order ID	Unit price	Product category	Order date	Customer	Order SKU	Quantity
1001	18	Accessories	2026-09-17	Northstar Bikes	sku_1001	2
1002	31	Accessories	2026-09-22	Miller & Finch	sku_1004	1
1003	42.50	Fitness	2026-09-29	Oakline Studio	sku_1002	4
1004	118	Furniture	2026-10-02	Harbor Clinic	sku_1007	3
1005	12.75	Kitchen	2026-10-06	Bright Kite Co	sku_1005	5
1006	24	Grocery	2026-10-09	Juniper Foods	sku_1008	2
1007	64	Home	2026-10-14	Clover Supply	sku_1003	1
1008	35	Kids	2026-10-18	Atlas Learning	sku_1010	6
1009	9.50	Office	2026-10-21	Pine & Pixel	sku_1006	2
1010	89	Electronics	2026-10-27	Summit Pets	sku_1009	1
1011	31	Accessories	2026-10-30	Blue Lantern	sku_1004	2
1012	18	Accessories	2026-11-02	Keystone Fitness	sku_1001	3

20 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you do a VLOOKUP between two sheets?

Export the Orders sheet and the Products sheet from Excel, then use a shared key such as SKU to match rows. The workflow looks up the product price and category for each order row and adds those details to the output. Rows that do not find a match stay unmatched, so you can review them separately.

How it works

How to use the Order Product Lookup workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Order Product Lookup: questions

Which file should you export from Excel?

Export the sheets that hold your source data, usually an Orders sheet and a Products sheet. The workflow reads the exported file and uses the columns you choose for matching.

What happens if a row does not match?

The row is left without a lookup result, so you can spot it in the output and fix the source data or the lookup key. It does not stop the other rows from being processed.

How do you change the lookup rules?

You change the rules by editing the steps in words, for example by choosing a different key column or different fields to return. If your data changes, update the matching rule and run the workflow again.