One VLOOKUP cell gives me a column list of returns
Comments
-
Yes it didn’t work.
-
Would like access to the sheets?
-
Yes It did not work. Would you like access to the sheets?
-
I saw that Paul answered already and that you are close to a solution it seems.
Let me know if I can help with anything else!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I found it...
=INDEX({Master Sheet Store # Column}, SMALL(COLLECT({Master Sheet Store Count Column}, {Master Sheet Run Name Column}, [Run Name]$1), [Store Count]@row))
That was my fault. Sorry about that. Give the above a try and see how it works out for you.
-
@Paul Newcome That did it!!!!! Thank you!!! this is a huge step for our planning believe it or not. I can move on to the next phases now that will truly put this all together.
Thank you for all the help and time, it is greatly appreciated!
Thanks
Scott
-
Happy to help! 👍️
Sorry for that initial mix-up, but I'm glad we were able to get it working for you,
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!