🔗 Link by key

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.”
Planning engineer — illustrative example

Link your tables in a minute

Try all of Tablio free for 28 days. No credit card, no commitment.