回复:

来源: 2006-10-19 11:51:49 [旧帖] [给我悄悄话] 本文已被阅读:

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