I am using LOOKUP and use the time value.
Also I am referencing the time outside of the array. If I reference
the time in the array, it returns the correct value. For instance, if
you use the array below
<A <B <C
11:00 1 11:30
11:15 2
11:30 3
11:45 4
12:00 5
The formula LOOKUP(A3, A1:B5) returns 3
But if you reference the value outside of the table, say in cell C1,
the formula returns 2.
--
jjhmbh
------------------------------------------------------------------------
jjhmbh's Profile:
http://www.excelforum.com/member.php...o&userid=29748
View this thread:
http://www.excelforum.com/showthread...hreadid=494626