Join data
Look up a rate by company and amount range
Find the rate for an amount within a company’s price bands. Join by company, then keep the band whose lower and upper limits contain the amount.
Join data
Match customer lists, find missing values, and combine spreadsheets. See how to solve everyday Excel problems with worked examples in JOIN SHEET.
Join data
Match contacts by email or phone within a company
Run company-plus-email and company-plus-phone joins separately, then combine the ID pairs. Exclude blank contact keys and remove repeated pairs.
Join data
Preserve blank source values in a lookup result
Keep blank amounts blank when joining sheets, and display the matching ID to tell missing values, recorded zeros and missing matches apart.
Join data
Keep records with missing IDs separate when joining both lists
Keep records from both sheets without matching genuinely blank IDs to each other. Retain source references so you can investigate them.
Join data
Keep master records that have no matching details
Keep every item in your master list when adding details from another sheet. Show missing matches as blanks without losing the master records.
Join data
Return every matching record for a list of codes
Join a list of codes to a detail table and keep every matching record. Check the expected number of rows when a code has several details.