Ever had that the Excel formula VLOOKUP start coming up with the wrong answer? Trouble is that most times it has the correct answer, but sometimes it doesn’t.
I found the answer on the internet, see below:
Sounds like you are using no range lookup value
if you don’t use false (or zero) it will need the leftmost column sorted in
and false also makes it look for the exact value and will return an error
otherwise but leaving it out or using true will lookup the largest value
less than or equal to the lookup value