Hi,
Probably still a rounding error.
The default vlookup is =.
So if the cell value is 101.499999999 but displays 101.50 Excel will return the 101.45%


John


"iguttin" wrote in message ...
I've tried rounding both the lookup table and the value in case this was a
rounding issue.

The stranger thing is that VLOOKUP works for *most* values, but every 4th
(or 8TH) value errors out. (eg. looking up 101.35% works, 101.40% works,
101.45% works but 101.50% doesn't)