Cross-Sheet Lookups Without Fragile Formulas
Stop wrestling with fragile VLOOKUPs and manual copy-paste. Pull matching data from one sheet into another in a single reviewable pass, and re-run it whenever the source changes.
Connect Smartsheet to StartWhy teams use it
Connect data between sheets
Match on a key column and bring in the values you need from a source sheet, no formulas required.
No more broken VLOOKUPs
Skip brittle formulas and cell links that break when columns move. Lookups are configured, not hand-coded.
Re-run anytime
Re-run the lookup whenever your data changes so the linked values keep up.
How it works
Choose source and target sheets
Pick the sheet to pull from and the sheet to fill in.
Match on a key column
Tell us which column links the two sheets together.
Pull the matching values
Select the columns to bring over and run the lookup.
Frequently asked questions
How is this different from a VLOOKUP?
A VLOOKUP lives in a cell and breaks when columns move or sheets change. This runs as a configured operation that matches on your key column and writes the values directly.
Can I look up across two different sheets?
Yes. You choose a source sheet to pull from and a target sheet to fill in, matched on a shared key column.
How do I keep the data up to date?
Re-run the lookup whenever the source data changes and the matched values refresh in the target sheet.
Is there a usage limit?
Previews and dry runs are unlimited and never count. Applying changes (a real write) is capped at 3 bulk runs per account per day while the tool is free, and a single run can span up to 5 sheets. The counter resets daily.
Prefer to do it by hand first?
How to write a VLOOKUP with a cross-sheet reference in Smartsheet, why INDEX/MATCH is sturdier, the reference limits to watch, and a formula-free alternative.
How to VLOOKUP in Smartsheet (Including Another Sheet) →Ready to get started?
Connect your Smartsheet account and try it in minutes.
Connect Smartsheet to Start