The errors arise due to rounding in the translation of the numbers from
binary to decimal. It's probably off in the 15th digit. Some of Excel's
functions are smarter than others, and correct for this rounding error, but
apparently MATCH isn't so smart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PaulW" wrote in message
...
Cheers both of you.

I am making E2 to be =E1+$E$1 and dragging down, at least I was.

How can they mathmatically not be correct though?
Especially when a =E6=C16 produces TRUE()?

I've used both your solutions, and its fixed, but I still can't get my
head
round the logical reason *why* it didn't work initially....

"bj" wrote:

if you used the drag down method on column E to generate ther numbers,
they
may not be exact. try goint to column F and entering
=round(E1,2)
and drag down.
use columm F as you match and try it.