You don't provide much information, but maybe you have omitted the final
argument for the Vlookup function. This optional argument, called
Range_lookup. determines if Vlookup looks for only an exact match or if an
approxiamte match is okay. From Excel 2003 help:

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.

Hope this helps,

Hutch

"unknown" wrote: