Hi dude. In the VLookup dialogue box, enter false in Range_lookup to force
an exact match. HTH
--
Sincerely, Michael Colvin


"Some Dude" wrote:

Sometimes when I do a VLOOKUP I get the wrong data. If the item I'm looking
up is not in the list, instead of returning a blank or N/A, Excel returns
the value of the next row. What gives?