Hi,

if you want the next highest value, please array enter this formula
(Ctrl+Shift+Enter)

=MIN(IF((D25:D28-$B$19)=0,D25:D28))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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: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?