請問一下~在EXCEL內 我想要設定 在B2為杯子時A2傳回的値為1 B2為盤子時A2傳回的値為2 B2為筷子時A2傳回的値為3 要如何設定?

[匿名]

2016-01-13 8:04 am

更新1:

=IF(D92="","",LOOKUP(D92{"杯子","盤子","筷子";... 他秀出來的值是都是2耶

回答 (3)

Daniel

2016-01-15 1:09 am

.
A2:
=MATCH(B2,{"杯子","盤子","筷子"},)

👍 2 👎 0

EXCEL迷

2016-01-13 1:20 pm

=IF(B2="","",(FIND(B2,"杯子盤子筷子")+1)/2)

👍 1 👎 0

[匿名]

2016-01-13 8:20 am

=IF(B2="","",LOOKUP(B2,{"杯子","盤子","筷子";1,2,3}))

👍 1 👎 0

收錄日期: 2021-04-28 15:49:33
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20160113000433AAF9ckz

檢視 Wayback Machine 備份