VLOOKUP
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.
|