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.
V Look Up
Hi
I Am Trying to find out if i can do a Vlookup from another sheet ?
Basicaly i have a sheet With items and Pricing from 3 Diferent Vendors
I want on a diferent sheet have all my items in a srop down list and the Rate should Be looked up from the Prcing sheet in other Words i want to Quote it based on a price list sheet
Comments
-
Hello,
There currently isn't a way to reference cells in other sheets with Smartsheet formulas but I've added your vote for this on our enhancement request list for further consideration.
To accomplish what you need using the LOOKUP function, the table and the items need to be on the same sheet.
More on the LOOKUP function can be found in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas#lookup
-
We also need this funktion higly... Thanks
Hope more Users need this function, too.
-
This feature would also been incredibly helpful for our team.
-
Same here!
If we'd like to switch some activities completely to smartsheet, it's not an option, it's a must!
+1 vote from me.
-
This would be a MUST HAVE feature!!
-
Adding my vote! +1 This should be a basic allowable function to help connect sheets.
-
Yes please, +1 from here for this feature.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives