Lookup formula still available?
Hi there!
Is the Lookup formula still usable in Smartsheet? I'm trying to do a lookup within a matrix of values, where I need to specify both a horizontal and vertical lookup criteria. From what I've found, it looks like Lookup would've been able to do it, but it doesn't look like that formula exists in Smartsheet now.
Thanks!!
Answers
-
VLOOKUP still exists, but I would suggest more of an INDEX/MATCH or INDEX/COLLECT depending on your exact setup.
-
Thanks! I've tried both INDEX/COLLECT and INDEX/MATCH, but the part that i get stuck is that I need to be able to look up a value using both a horizontal and vertical identifier. I created a quick sample set of data similar to what I'm working with - basically, I'm looking for a value based on the flavour (column on the left) and the Store number list across the top. eg. If the parameters were to look for the quantity at Store 2 for Premium, it would return 32.
-
Then you would want an INDEX/MATCH/MATCH
=INDEX({Table of Data to Pull}, MATCH(Flavour@row, {Table Left Column}, 0), MATCH([Store Number]@row, {Table Top Row}, 0))
-
YES!!!!!! That did it!! Thank you!!!!!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!