判斷合併格是否有指定字符 (12398)

H5{=IF(OR((LOOKUP(ROW($1:$19),ROW($1:$19)/(A$4:A$22<>""),A$4:A$22)=G$4)*ISNUMBER(FIND(","&G5&",",","&C$4:C$22&","))),"YES","NO")