why does the vlookup function not work using time?
 

When i tried using the vlookup function to look up time and display the cell
next to it, there was a glitch every 20 minutes or so (in the time typed in)
it would show the cell above the one it should. I was using a 5 min
interval in my 'time'.

How can i fix this?

why does the vlookup function not work using time?
 

Vick, it should work.

take a look if your table are in ascending order.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Vicky" escreveu:

When i tried using the vlookup function to look up time and display the cell
next to it, there was a glitch every 20 minutes or so (in the time typed in)
it would show the cell above the one it should. I was using a 5 min
interval in my 'time'.

How can i fix this?