this way

來源: bakoma 於 2006-10-05 20:10:36 [] [博客] [舊帖] [給我悄悄話] 閱讀數 : (65 bytes)

Copy and paste this in E2:
=LOOKUP(D2,$G$2:$G$100,$H$2:$H$100)

請您先登陸，再發跟帖！