Match doesn't work all the time?
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.
|