Lookup To Return Multiple Results — Using JOIN, COLLECT



I am trying to use JOIN, COLLECT to return multiple results but just can't seem to get it to work.

This is what I have:

=JOIN(COLLECT([Column111]:[Column111], [Column7]:[Column7], [Column1]@row, "N/A"))

[Column111]:[Column111] is the range of the data I want to be returned

[Column7]:[Column7] is the range of where to look for the data

[Column1]@row is the cell that contains the data I want to find within the range

N/A is the result I am looking for if there are no matches

Any ideas?

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!