Avatar of hermesalpha
Flag for Paraguay

asked on 

Why doesn't my VLOOKUP formula work even though it work for another post three columns to the left?

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?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon