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)

请您先登陆，再发跟帖！