🔗 Link by key
XLOOKUP without writing formulas…
XLOOKUP without writing formulas…
even from another file.
Pick the source table, from this file or another one, and the column the two share. Tablio brings the columns you want, as fixed values or a real XLOOKUP formula that works in Excel, and warns you about duplicate keys.
- No credit card
- Your files are never stored
- Arabic & English
The problem
Why is VLOOKUP such a chore?
- A long formula, typed and dragged for every column; one wrong range breaks it.
- The table you need is in another file, so you copy it in first.
- A duplicate key gives a wrong answer without you noticing.
The solution
How it works
Press “Link by key”
In the table view (managers).
Pick the source and the key
The source table from this file or another, and the shared column, up to 3 levels.
Pick what to bring
The columns you need: fixed values or an XLOOKUP formula, into new or existing columns, then “Link”.
What you get
The result
- Links within the file or to another Excel file.
- Up to 3 levels of links.
- Fixed values, or a real XLOOKUP formula that keeps working in Excel.
- A count of duplicate keys and unmatched rows before you rely on the result.
“I link the site log to the contractors list straight from its own file, without a single formula.”
Link your tables in a minute
Try all of Tablio free for 28 days. No credit card, no commitment.
Discover more of Tablio
📈Dashboards & report designer
🗂️Project-management templates
✓Instant validation
✨Smart edit
🧹Quick clean & replace
↶Steps log & undo
📱Works on mobile
⇄Merge & advanced merge
👁Manager review
📊Instant reports
ƒFormulas stay intact
🔐Member permissions
🎨Sheet designer & templates
⬇Password-protected export
🔒Privacy & security