Excel 2007 : Lookup of rounded number fails for certain numbers

In the attached Excel 2007 workbook, test values that round to -0.102 or -0.104 lookup incorrectly, returning the next higher result in the table. Test values that round to the the other values in the lookup range return correct results (e.g. -0.100999, -0.105000). Truncating the rounded value causes all lookups to work, even though the rounded and truncated values test to equality.

Can someone help me understand why the rounded loookups sometimes fail and justify why the truncation step (seemingly a no-op) is the correct resolution?

It's Excel precision quirks causing that.

See here for details.

If you use =ROUND(B1,3) instead of MROUND() it works...