Alternative to VLOOKUP in SmartSheet?

Anna_SS

Is there a 'bolt-on' in Smartsheet that does the same thing as VLOOKUP?

 

Ian

use the LOOKUP formula.

You can also use index and match together

 

 

Rhinoceross

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.

 

Daniel Stein

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

J. Craig Williams

I really hope the VLOOKUP across sheets is better than the DataMesh I used.

Craig

fmazzella33791

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 

Daniel Stein

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

premnath.rao

Hi Daniel, is there any update to this? we are desperately looking for this functionality. thx, Prem

Shaine Greenwood

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

SmartGeek

Hello, 

Can you route to me the documentation where the features of these apps is documented. 

Thanks

Shaine Greenwood

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

Cam Swift

• 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.