Vlookup error

I cannot get a formula to work... that has worked for over a year.

I am provided a cost per pound (say $1.10). I then "lookup" the cost on the matrix to find the price two columns over. The only hitch is, I have to multiply it by 100 because the matrix is written in hundredweight.

I have no problem with $1.20 or with $0.925, etc.... But $1.10 will not work. I see no rounding issues.

Plug in a new cost in the green box, you'll see that they work fine (units of $0.0025). But $1.10 does not (and I suspect other costs may not work either... but this is the first one I've found).

Thank you much

It's probably a precision error...

Try:

=VLOOKUP(ROUND(E5*100,2),A:C,3,0)