My guess is that your problem is your column is not sorted. You need to have
your times in ascending order for Vlookup to work.
Regards,
Fred.
"GAIDEN" wrote in message
...
I'm trying to lookup the time value 4:05:00 PM or the next highest time
value.
I have:
B19 = 4:05:00 PM C19 = VLOOKUP(B19,D,1) D25 = 4:05:13 PM
D26 = 4:05:10 PM
D27 = 4:05:09 PM
D28 = 4:00:06 PM
I thought I'd get 4:00:06 PM as my answer but all I keep getting is
8:02:49
AM. What am I doing wrong?