Lookup To Return Multiple Results
I've done some research, but am struggling to find the best solution on this one. I am trying to do a lookup from one sheet to another based on a Unique ID. A VLOOKUP returns only one result, but I'd like to return all of them back to one cell in the other sheet. It seems like some combination of COLLECT, JOIN, etc. might be able to work, but I'm not seeing how to do it immediately.
Question, is there a way to do this with the functions available in SmartSheets?
As always, thanks for the help.
Help Article Resources
Check out the Formula Handbook template!