Cross-Sheet Lookups That Stay Up to Date
Stop wrestling with fragile VLOOKUPs and manual copy-paste. Pull matching data from one sheet into another automatically and keep it current as rows change.
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.
Stays current
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.
Does it keep the data up to date?
Re-run the lookup whenever the source data changes and the matched values refresh in the target sheet.
Ready to get started?
Connect your Smartsheet account and try it in minutes.
Connect Smartsheet to Start