How to do lookup for multi select dropdown cell to return results for all selected items in cell?

Xlookup

Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values.

Sheet 1 screenshot (yellow highlight is where I want formula to be):

Sheet 2 screenshot (contains table of lookup values):

I'm trying formula from this question from before: https://community.smartsheet.com/discussion/comment/346853#Comment_346853

But I'm not getting it to work and get #UNPARSEABLE error

=JOIN(DISTINCT(COLLECT({DocumentName}, {RowID}, CONTAINS(@cell, GroupedList@row ))), SUBSTITUTE($LineBreak$1, "-", ""))

DKazatsky2

Hi @Xlookup,

Give this a try.

=JOIN((COLLECT({DocumentName}, {RowID}, CONTAINS(@cell, GroupedList@row))), CHAR(10))

Hope this helps,

Dave