excel判断某单元格内是否包含某字段,且还有人数条件下,返回不同的数值...答:假如表格结构如我下图所示,在C2单元格输入公式=IF(AND(ISNUMBER(FIND("优秀",A2)),B2=2),"1000元",IF(AND(ISNUMBER(FIND("优秀",A2)),B2=3),"1200元",IF(AND(ISERROR(FIND("优秀",A2)),B2=2),"500元",IF(AND(ISERROR(FIND("优秀",A2)),B2=3),"600元",""...
怎样用excel判断单元格中包含某字段并且返回该字段?答:=IF(COUNT(MATCH("*"&A2&"*",E:E,0)),-LOOKUP(1,-RIGHT(LEFT(INDEX(E:E,MATCH("*"&A2&"*",E:E,0)),LEN(INDEX(E:E,MATCH("*"&A2&"*",E:E,0)))-2),ROW($1:$10))),"")下拉,若不能解决,就把问题作为内容(邮件主题一定要包含“excel”,...