反向查找对应数据

秃头发师

=TEXTJOIN(",",TRUE,UNIQUE(TOCOL(IF(ISNUMBER(FIND(J2,$B$2:$G$4)),$A$2:$A$4,""))))
=TEXTJOIN(",",TRUE,IF(ISNUMBER(FIND(J2,$B$2:$G$4)),$A$2:$A$4&("["&$B$1:$G$1&"]"),""))

waternew

=TEXTJOIN("、",,INDEX($A$2:$A$4,UNIQUE(TOCOL(IF(FIND(J2,$B$2:$G$4)>0,ROW($1:$4),""),3)),))

守候_CJ

K2公式：

=LET(x,TOROW(IF(ISNUMBER(FIND(J2,$B$2:$G$4)),$A$2:$A$4,""),3,TRUE),y,UNIQUE(FILTER(x,x<>"",""),TRUE),z,TEXTJOIN("、",TRUE,y),z)

下拉填充