it's probably not a bug, per se, but rather because of small internal
rounding errors (see

http://cpearson.com/excel/rounding.htm

for a detailed explanation). I can replicate your results in XL04. This
formula can be used as a workaround:

=VLOOKUP(ROUND(C6;2);$A$2:$B$3;2;TRUE)


In article ,
"AndreasN" wrote:

Is it a bug or am I doing something wrong?