Index and Match for multiselect column?

Hi all, I'm a little stumped on this one.

I am trying to extract the selection(s) people are noting in a multi-select column in another sheet. I set up a marker in both sheets to I can use that as the indicator on where I can line up the Match formula but I get a #INVALID DATA error. Is there something simple I'm missing? My formula is as follows:

=INDEX({Type}, MATCH(Marker@row, {Marker}, 0), 0)

This is the first time I'm working with a formula for a multiselect column so I am wondering if there's something I am missing. I don't necessarily need to extract all the multi options - I am mostly looking for a specific item that is among the drop down list so I am open to alternatives.

Any help would be greatly appreciated, thank you!


Best Answer