My lookup table is like this:

9:30:55 AM 440.43
9:30:56 AM 440.22
9:30:57 AM 440.03
9:30:58 AM 440.44
9:30:59 AM 440.06
9:31:00 AM 9999

My lookup value is this:

9:37:58 AM
9:30:55 AM

MY lookup formula is this:

=VLOOKUP(R617;table2;2)

but the value returned is 9999 and 440.43 respectively.

If I change the formula to =VLOOKUP(R617;table2;2;false) it returns #N/A for
all lookups.

Any suggestions are appreciated.

Thank you in advance.