The 4th argument of the function is range_lookup
Range_lookup is a logical value that specifies whether you want
VLOOKUP to find an exact match or an approximate match. If TRUE or
omitted, an approximate match is returned. In other words, if an exact
match is not found, the *next largest value that is less than
lookup_value * is returned. If FALSE, VLOOKUP will find an exact match.
If one is not found, the error value #N/A is returned.

If the list is sorted you can find the right criteria with a
combination of true and false values.


--
Avner
------------------------------------------------------------------------
Avner's Profile: http://www.excelforum.com/member.php...fo&userid=5078
View this thread: http://www.excelforum.com/showthread...hreadid=276503