Excel中如何查找出某一列中的数据包含某一列里面的特定字符数据,并返 ...答:在D2中输入或复制粘贴下列公式 =IFERROR(LOOKUP(1,0/FIND(C$2:C$5,B2),C$2:C$5),"无关键词")或 =TEXTJOIN(",",,IF(ISNUMBER(FIND(C$2:C$5,B2)),C$2:C$5,""))下拉填充
excel,如何用函数在一串字符内查找多个不同字符?答:如下图,B2=IFNA(IF(MATCH(TRUE,ISNUMBER(FIND({"A","C","D"},A2)),),"是"),"")——下拉填充。或者,=IFERROR(IF(MATCH(TRUE,ISNUMBER(FIND({"A","C","D"},A2)),),"是"),"")示例