回复：

add one more parameter =vlookup(,,,false)

If you leave it blank, VLOOKUP returns the closest match to your search term. And you must sort the values in the first column of your table array in ascending order.
By setting it to false, you ask for an exact match.

see here:
http://office.microsoft.com/en-us/assistance/HA010563201033.aspx

所有跟帖： 

• It works! 你太牛了! 谢谢你~~~ -阿桃~- ♀ (0 bytes) () 10/19/2006 postreply 12:03:49

• 不见得！ -ohlalala- ♀ (26 bytes) () 10/19/2006 postreply 18:55:41