如果单元格包含某字段,则显示为有,多个条件?答:=IF(COUNTIF(A1,"*一班*"),"周老师",IF(COUNTIF(A1,"*二班*"),"方老师",IF(COUNTIF(A1,"*三班*"),"王老师","")))或者 =IFERROR(LOOKUP(MATCH(1=1,ISNUMBER(FIND({"一班","二班","三班"},A1)),),{1,2,3},{"周老师","方老师","王老师"}),"")如须添加如图格式 ...
Excel如何把一个表格中包含某字段的单元格里面内容平移到同一行的另...答:然后向下填充公式;② 同理,在J2单元格中输入函数:=IFERROR(OFFSET($E2,,MATCH("*手机*",$E2:$G2,0)-1,,),"")然后向下填充公式;③,后面的也是一样的,依次在K2单元格中输入:=IFERROR(OFFSET($E2,,MATCH("*邮箱*",$E2:$G2,0)-1,,),""),在L2单元格中输入:=IFERROR(OFFSET...