Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Alternative to VLOOKUP in SmartSheet?
Is there a 'bolt-on' in Smartsheet that does the same thing as VLOOKUP?
Comments
-
use the LOOKUP formula.
You can also use index and match together
-
There is a bolt-on that offers full VLOOKUP capability across sheets. It's called Data Mesh, and is one of 4 premium add-ons to Smartsheet. Pivot App, Status View App and Calendar App are the other three. Each premium app is $2400/yr, or there is a package that includes all 4 apps for $4800/yr. There is also a one-time set up charge of $2000.
Extremely pricey add-ons for 2 pieces of key functionality that are built into E xcel, G oogle Sheets, and Numbers.
-
We are currently working on native cross-sheet formulas and VLOOKUP, coming in early 2018, so stay tuned.
In the meantime:
- As Ian mentions, you can use LOOKUP today if your data is in a single sheet, or linked in from another sheet using cell links.
- And we also have Data Mesh as a paid add-in that performs cross-sheet lookups.
Thanks,
Daniel
-
I really hope the VLOOKUP across sheets is better than the DataMesh I used.
Craig
-
Hi, Daniel
Can you give an update as to where the VLookup (across sheets) stands in the pipeline Will it still make Q1 ''18? Game changer, imho.
Thanks
-
Yes, we are still tracking to deliver cross-sheet formulas in Q1 of 2018.
In the meantime, we're always interested to hear about customer use cases. How are you planning to use VLOOKUP?
Thanks,
Daniel
-
Hi Daniel, is there any update to this? we are desperately looking for this functionality. thx, Prem
-
You can now reference data from other sheets in formulas!
Create a master lookup table sheet and use VLOOKUP to find data on another sheet.
More information on this new feature is available in our help center: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
-
Hello,
Can you route to me the documentation where the features of these apps is documented.
Thanks
-
Hello SmartGeek,
You may not need our premium data mesh application anymore.
We now have the ability to reference data across multiple sheets in Smartsheet. More information on this is available in our help center: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
We also have a VLOOKUP function, more info here: https://help.smartsheet.com/function/vlookup
-
- Whats the story with the vlookup function. Its very limited, since there are 25000 cell limitations in place. Are you going to modify this in the future?
Are there any better alternatives. Im getting to the point where the limitations in smartsheet are outbalancing the actual features and we may be needing to switch to another app.
