Index Match Function with Multi Select Dropdown

ssuddendorf

Hello,

I'm looking to create a formula that will look at a multi select dropdown and use that to match to a reference table on another sheet and give back a value for each item selected.

This is a copy of the reference table I'm using.

My desired result is below.

Mike TV

@ssuddendorf

Sorry but I cannot make any connections between the reference table and your desired results in the Follow Up column.

ssuddendorf

@Mike TV

What I think the formula should to be is

=INDEX({Follow up}, MATCH([Why? - Overall feeling]@row, {Follow Up Plan Range 1}, 0))

But that is getting me an error of #NO MATCH

The column 'Why? - Overall feeling' is just a list of the options available to select from in the dropdown on the other sheet.

Mike TV

@ssuddendorf

I think this thread has the type of formula you'll need to use with a multi-select drop down column:

https://community.smartsheet.com/discussion/78916/index-and-match-using-dropdown-multi-select-column

ssuddendorf

@Mike TV

Based on that thread I tried

=JOIN(COLLECT({Follow up}, {Why feeling}, HAS([Why? - Overall feeling]@row)), ", ")

but I'm getting an INVALID OPERATION error