Basic merge

Basic VLOOKUP: Add Customer Details to an Order List

Emma, an operations coordinator, enriches a daily order export with customer names, emails, and regions by matching Customer ID.

Problem

Emma sends a daily fulfillment report to the warehouse. Her order export only includes Customer ID, but the warehouse team needs customer name, email, and region. Instead of writing three VLOOKUP formulas, she uses SheetMatch to bring the customer columns into the order list in one pass.

Demo Files

Main file: Daily Orders

Order ID	Customer ID	Order Date	Amount
1001	C-102	2026-05-01	$240
1002	C-118	2026-05-02	$89
1003	C-204	2026-05-03	$310

Lookup file: Customer Directory

Customer ID	Customer Name	Email	Region	Account Manager
C-102	Acme Supply	ops@acme.example	West	Mia
C-118	Northstar Co	ap@northstar.example	East	Leo
C-204	Bright Labs	finance@bright.example	Central	Nora

Recommended Options

Trim extra spaces to avoid IDs with accidental whitespace.
Use first match if each Customer ID should appear once in the customer table.

Result Preview

Result preview

Order ID	Customer ID	Order Date	Amount	Customer Name	Email	Region
1001	C-102	2026-05-01	$240	Acme Supply	ops@acme.example	West
1002	C-118	2026-05-02	$89	Northstar Co	ap@northstar.example	East
1003	C-204	2026-05-03	$310	Bright Labs	finance@bright.example	Central

What This Shows

This is the classic VLOOKUP use case: enrich a main spreadsheet with columns from a reference table.
Emma can pull several customer fields at once, so the order list is ready for the warehouse without extra formulas.