What formula(s) do I use to reference a Multi-select column in another sheet?
Normally I use Index(Match()) to pull in the value from one row into another sheet. That doesn't appear to work when the source is a multi-select column. I've tried Index(Collect()) but can't seem to get the syntax right. Any help would be greatly appreciated.
Answers
-
Try the HAS function
-
Thanks but I don't see how that would work for my use case. I'm essentially trying to pass the values selected within the Team cell to another sheet where the Login ID is the same using a cross sheet reference. I'm trying to retain the characteristics of the multi-select column in the look up sheet when returned to the destination sheet. Hope this helps clarify.
-
If you want to bring in all selected values try an Index + match with a substitute to add line break back in
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!