Lookup To Return Multiple Results — Using JOIN, COLLECT

Options

Hello,

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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!