How to stop writing multiple vlookup formulas — use an excel sheet join instead
- Step 1Prepare File A (the main data) and File B (the lookup table) — Identify the shared key column in each file (e.g. Product ID).
- Step 2Configure the join — Upload both files. Enter the key column name in each. Choose left join to keep all main data rows.
- Step 3Download the merged file — All columns from File B are appended to File A rows. No VLOOKUP formulas needed.
Frequently asked questions
What if the key column has different names in each file?+
You specify the key column name separately for each file — they can have different header names as long as they share the same values.
How is this better than Power Query Merge?+
Power Query requires Excel for Desktop and a desktop install. This tool works in any browser — Chromebook, iPad, Linux — with no install.
Does it handle keys with mixed types (numbers vs text-stored numbers)?+
Keys are compared as strings after toString() conversion. '123' and 123 will match. Mixed-type key mismatches are flagged in the summary.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.