I think you are entering something incorrectly, as it returns 3 for me.

Is A1:A5 typed in, or a formula result? I can't get 2 no matter what I have
tried.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jjhmbh" wrote in
message ...

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