If you want an exact match then you need to use a 4th parameter in the
VLOOKUP function and set it to 0 or FALSE.

Hope this helps.

Pete

On Oct 12, 6:48*pm, Summerfun
wrote:
The VLOOKUP function is returning a value exactly one row above the row it
should be using.