Examples
Practical Spreadsheet Matching Examples
See how SheetMatch works in common business scenarios. Each example shows a main file, a lookup file, the matching setup, and the merged result.
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.
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.
Left-side lookup
Look Up Columns on the Left Side of the Match Column
Priya, a finance specialist, matches invoices to a bank export where the payment status sits to the left of Invoice No.
Clean match keys
Clean Messy Match Keys: Ignore Case and Trim Spaces
Lena, a marketing ops manager, matches webinar leads to CRM contacts even when email capitalization and trailing spaces differ.
Duplicate matches
Handle Multiple Lookup Matches for the Same Key
Marcus, a customer success lead, reviews accounts with multiple support tickets and chooses how duplicate matches should appear.