You have mentioned that you would like to get the next highets time value for
4:05:00 PM, but at the same time you are saying that you would like to get
4:00:06 PM as your result. How it's possbile?

Becuase the value you want to get as a result should be greater than 4:05:00
PM, but the value you are mentioning as your desired result is 4:00:06 PM .
Just have a look in these times you will notice that 4:00:06 PM is lower
value when comparing to 4:05:00 PM. Becuase the 06 is seconds not minutes.

Apart from this the Vlookup formula is not perfect. = VLOOKUP(B19,D,1) it
should be like this =VLOOKUP(B19,D,1,FALSE) OR = VLOOKUP(B19,D,1,0). But
this also will not get the next highest time value.

You can use =LARGE(D,1) for first highest time value in D Column, and you
Can change the value 2 instead of 1 to get the second highest value (i.e.)
=LARGE(D,2) like this you can get your desired Results.

All the Best!

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"GAIDEN" wrote:

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?