this way

來源: 於 2006-10-05 20:10:36 [博客] [舊帖] [給我悄悄話] 本文已被閱讀：次

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