更新1:
=IF(D92="","",LOOKUP(D92{"杯子","盤子","筷子";... 他秀出來的值是都是2耶
請問一下~在EXCEL內 我想要設定 在B2為杯子時A2傳回的値為1 B2為盤子時A2傳回的値為2 B2為筷子時A2傳回的値為3 要如何設定?
回答 (3)
2016-01-15 1:09 am
.
A2:
=MATCH(B2,{"杯子","盤子","筷子"},)
A2:
=MATCH(B2,{"杯子","盤子","筷子"},)
2016-01-13 1:20 pm
=IF(B2="","",(FIND(B2,"杯子盤子筷子")+1)/2)
2016-01-13 8:20 am
=IF(B2="","",LOOKUP(B2,{"杯子","盤子","筷子";1,2,3}))
收錄日期: 2021-04-28 15:49:33
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20160113000433AAF9ckz