I have a column:

```
C1: 0:8:35
C2: 0:8:40
C3: 0:8:45
and so on.
```

D1: 0:8:40

I'm trying this :

VLOOKUP(C2,C1..C30,1,TRUE) returns: 0:8:40

(1 - we have one column) (TRUE - range lookup - should give the closest number in ascending order !

When I try VLOOKUP(D1,c1..c30,1,TRUE) returns 0:8:35

Altough C2 and D1 have the exact same value (if(c2=d1, "ok", "not ok") returns OK.

I am using range lookup so I can find also 0:8:36 ect...

Any ideas ?

IMPORTANT EDIT: it works ok when you enter the numbers in the search column. if you create the list using 0:8:35 and each next cell as the previous + 0:0:05 - than the error occurs !! checked the evaluation of the calculation and in both case it's evaluates to the same number, but yields different results !