I have this VLOOKUP formula in my Excel:
And it finds the value 1.7 in column 12 from the left without problems.
Then I change to column 15 (otherwise everything else is exactly the same):
But now Excel does not find the value 1000 (even though it's there)! Why? And what needs to be changed so I get the value 1000 retrieved?