Dear JohnK

What is happening is that it is returning the value corresponding to
the approximate match and not the exact match.

Specify the last parameter as FALSE and it will return the value
corresponding to the exact match. Should an exact match not be found,
an error value shall be returned.

The default value is TRUE (when not specified) indicating an inexact
search - this returns the largest value less than the search or lookup
value.

Hence, you are getting what you are getting.

Hope this helps!


Best regards


Deepak Agarwal


--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345
View this thread: http://www.excelforum.com/showthread...hreadid=397653