Believe it or not...

"1:" is being evaluated as 1:00 AM or 0.0417

The lookup_value 1.00001 is greater than any value in the
lookup_vector --{"1";"1:"} so the result is the *last* number in the
lookup_vector that is less than the lookup_value. And, that number is "1:"
(1:00 AM or 0.0417).

I've run across this sort of thing before where you'd least expect it so now
I'm "aware" of the possibility. For example, in certain situations na (10a)
or np (3p) could also be evaluated as "time". This resolves back to Excel's
eagerness to "identify" times/dates.

--
Biff
Microsoft Excel MVP


"F. Lawrence Kulchar" wrote in
message ...

Why does:

=LOOKUP(1.00001,--{"1";"1:"})

return a value of 0.0417 ??

Thanks,

FLKULCHAR