本帖最后由 cutecpu 于 2019-10-22 15:37 编辑
我大概知道為什麼了:
1. 我這邊 {"碗","锅","碟子","椅子"} 依升序的結果是:
所以 LOOKUP("碗",{"碗","锅","碟子","椅子"}) 時,因為 "碗" < "锅",所以會 match 到 "碗" → 得到1.3
2. 你那邊 {"碗","锅","碟子","椅子"} 依升序的結果是:
所以 LOOKUP("碗",{"碗","锅","碟子","椅子"}) 時,因為 "碗" > "锅" 且 "碗" < "椅子",所以會 match 到 "碟子" → 得到2.1
結論: 我應該要用 VLOOKUP 做精確比對 → VLOOKUP("碗",{"碗",1.3;"锅",2.1;"碟子",2.1;"椅子",1.8},2,0)
感恩!南無阿彌陀佛!
|