Hi,
if you want the next highest value, please array enter this formula
(Ctrl+Shift+Enter)
=MIN(IF((D25
28-$B$19)=0,D25
28))
--
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,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?