VLOOKUP can return a value from the wrong row when the search key is not unique, the range is sorted differently than the formula assumes, or the lookup is approximate by default. The function ran; it matched something other than the row you had in mind.
Stub