this way

来源: 于 2006-10-05 20:10:36 [博客] [旧帖] [给我悄悄话] 本文已被阅读：次

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