AD-HOC
Match & look up across spreadsheets
Automates VLOOKUP, INDEX-MATCH and SUMIFS work: load two or three files, pick the keys, review the diagnostics, then run.
AFile A
BFile B
CFile C
optional
Files are processed entirely in your browser — nothing is uploaded or stored.
Ask in plain English
Describe the match you need. The AI proposes a plan using only file names, column headers and column shapes — never your cell values. Nothing runs until you press Run.
Ctrl/⌘ + Enter to submit
Operation
Choose the files, the matching keys and what to bring back. Nothing runs until you press Run.
Load at least two files to build an operation.
Left key & cleanup
Load a file first.
Right key & cleanup
Load a file first.
Columns to bring back from the Right
Load a file first.
Calculated columns & flags
Use [Column] references, numbers, + − × ÷, parentheses, comparisons, ROUND, ABS, IF — e.g. [Budget] - [Actual]. Flags show their label when the rule is true.
Match diagnostics
Checked automatically as you choose keys — before anything runs.
Choose key columns on both sides to see match rates.