Formula to use cell with comma separated values as Lookup value

[nsa1]

Can Index and Match function be combined to assign values separated in value column by comma and variable column by carriage return (Char(10))? See below as an example

formula =IF(ISNA(MATCH($E$1,$B2:$B4,0)),"",INDEX($A2:$B4,MATCH($E$1,$B2:$B4,0),1))

 

[Peter_SSs]

Duplicate to: Why do Index and Match do not work when you've multiple numbers in Cell

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.