回複:

來源: 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