Question: why vlookup returns wrong value?
Answer: This is a dangerous default because VLOOKUP may quietly return an incorrect result when it doesn't find your lookup value. ... As a result, when VLOOKUP finds a value that's greater than the lookup value, it will fall back, and match a previous value.