I'm having a wierd problem with Excel 2000.

I have a table with two columns that matches a certain delinquency rate to a borrowing rate. So column one has values of 0 to 100% in 1% incraments. Column two has different borrowing rates ranging from 75% to 0%.

I have another table on which delinqency rates are derived from different calculations. I then have formulas where I round up the derived calculations to the nearest 100th place, and than use that delinquency rate to match my table and get a borrowing rate.

This works fine, except that values that round to .21 (21%) and .24 (24%) result in #N/A errors when I do the lookup, whereas other values do not (though I have not tested every possible value). If I replace the derived value with a typed value, it works. In other words, if I point to a cell that has a value of .24 from a rounding a calculation and plug it in to my lookup formula - I get the error. If the same formula points to a hard-coded value of .24, it works.

I've used index/match functions and vlookup for the lookups, and I've used roundup and truncate for the rounding, and I get the same error - those particular values can't be matched. What's going on?

Thanks in advance for any help.