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
-
Disregard... My reference wasn't pulling from the column I needed it to......
Answers
-
Disregard... My reference wasn't pulling from the column I needed it to......
