201401函中班课前练习题06

蓝粆

{:02:}  才发现我把这题给忘了~~用index交个   哇咔咔~虽然有点臭跟长~

1. =INDEX({"";"设计1部";"设计2部";"设计3部";"设计4部"},MAX(IF(ISERR(FIND({"JHJD";"KSKS";"JHBP";"JHZJ"},B2)),1,ROW($2:$5))))

复制代码

李建军

=IF(COUNTIF(B2,"*JHJD*"),"设计1部",IF(COUNTIF(B2,"*JHZJ*"),"设计4部",IF(COUNTIF(B2,"*JHBP*"),"设计3部",IF(COUNTIF(B2,"*KSKS*"),"设计2部","")))){:1212:}

jio1ye

1. =IF(ISERR(FIND("JHJD",B2)),IF(ISERR(FIND("JHZJ",B2)),IF(ISERR(FIND("JHBP",B2)),IF(ISERR(FIND("KSKS",B2)),"","设计2部"),"设计3部"),"设计4部"),"设计1部")

复制代码

裹脚布，这就是我的水平咩~

车仁静

交练习~~~~

xcnclzy

1. =IFERROR(VLOOKUP(MID(B2,MIN(FIND({"JHJD","KSKS","JHBP","JHZJ"},B2&{"JHJD","KSKS","JHBP","JHZJ"})),4),{"JHJD","设计1部";"KSKS","设计2部";"JHBP","设计3部";"JHZJ","设计4部"},2,),"")

复制代码

tianyiyi

好难{:091:}先教再慢慢想

1. =IF(ISERROR(FIND("JHJD",B2)),"","设计1部")&IF(ISERROR(FIND("KSKS",B2)),"","设计2部")&IF(ISERROR(FIND("JHBP",B2)),"","设计3部")&IF(ISERROR(FIND("JHZJ",B2)),"","设计4部")

复制代码

笨笨四

LOOKUP(99,FIND({"";"JHJD";"JHZJ";"JHBP";"KSKS"},B2),{"";"设计1部";"设计4部";"设计3部";"设计2部"})

天龙九部

1. IFERROR(LOOKUP(MATCH(1,SEARCH({"*JHJD*";"*JHZJ*";"*JHBP*";"*KSKS*"},B2),),{1;2;3;4},{"设计1部";"设计4部";"设计3部";"设计2部"}),"")

复制代码

contending

=IF(ISNUMBER(SEARCH("*JHJD*",B2)),"设计1部",IF(ISNUMBER(SEARCH("*JHZJ*",B2)),"设计4部",IF(ISNUMBER(SEARCH("*JHBP*",B2)),"设计3部",IF(ISNUMBER(SEARCH("*KSKS*",B2)),"设计2部",""))))

Excel学徒123

=IF(IFERROR(FIND("JHJD",B4),0),"设计1部",IF(IFERROR(FIND("JHZJ",B4),0),"设计4部",IF(IFERROR(FIND("JHBP",B4),0),"设计3部",IF(IFERROR(FIND("KSKS",B4),0),"设计2部",""))))    IF吊炸天  哈哈