在B1單元格輸入公式後按SHIFT+CTRL+ENTER結束
=CHOOSE(MATCH(,0/FIND({"冰激淩","汽水","蛋糕"},A1),),"冰激淩","汽水","蛋糕")
第二個問題
=CHOOSE(MATCH(,0/FIND({"冰激淩","汽水","蛋糕"},A1),),"冷飲","冷飲","蛋糕")