You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"FLKulchar" wrote in message
...
Thank you very much for your expert analyses!
I was perplexed,
FLKulchar
"T. Valko" wrote in message
...
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