View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
PaulW PaulW is offline
external usenet poster
 
Posts: 130
Default 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.