Snasui Excel Forum

Hi there,

I need your help how to write formula to get name from column b base on lookup in column C.

I attach a sample

Note the output in color cells
TY

Try with this formula,

Excel Version 2016+ in D2

=MID(CONCAT(LOOKUP(FILTERXML("<t><s>"&SUBSTITUTE(C2,",","</s><s>")&"</s></t>","//s"),$A$2:$A$13,","&$B$2:$B$13)),2,255)

Enter and copy down.

Thank you