why does the vlookup function not work using time?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookups not working 2
Vlookup Copy Formula 2
vlookup formatting problem 1
How to use VLookup with a range of numbers? 3
vlookup 19:50 3
vlookup 2
VLOOKUP return cell location and hyperlink 0
vlookup multiple data 11

Back
Top