RE: VLookup - finding wrong value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks.

That seems to work (adding a minute to the data), I can't say as I'm crazy
about that solution, but it works.

Thanks for your help.


"pdberger" wrote:

Tomic --

Your example may describe one or two issues. First -- how vlookup works.
It counts down the left column until it gets to the first value equal to or
less than the test value, then GOES BACK UP ONE ROW to get the value to
return. The way to fix this problem is to change 10:00AM to 9:59AM, and the
other times as well. That should fix the problem. Check by putting in a
time of 10:07AM, or something not right on a 'dividing line'. If not, then
you may not have your times set up correctly.

HTH

"tomic" wrote:

I am trying to use a vlookup formula to lookup data based on a time, but it
is not always giving me the correct value. It seems like if the time entered
is before noon time (12 PM) it returns the wrong value Anything after 12PM is
ok. Here is the formula I'm using. Any help would be appreciated.

Sheet = Lab Results
A B
Time Result
9:30 AM 2
9:45 AM 3
10:00 AM 4
11:30 AM 5
12:30 PM 6
1:30 PM 10

On a seperate sheet an operator enters another time into cell B5, and in C5
I have the following formula.

=vlookup(B5,Lab Results!$A$2:$B$7,2)

If I enter in 10:00 AM into B5, I get 3 in C5, when I would expect to get 4.

Thanks.


.

Relevant Pages

  • Re: 2.6.31 -> 2.6.32 Sound and video regressions
    ... Screen is flickering/glitching like crazy in X. ... randomly or when conky is refreshed, when the mouse cursor moves and ... they can probably fix it. ... or later, show a single colour (which is, presumably, the result of a display ...
    (Linux-Kernel)
  • Re: Meeting with the SS PHD
    ... you gotta tear the whole thing down, fix the broken piece and then build it ... I must be crazy, who else would go through a nasty breakup then 2 ... days later be tearing apart his ex lovers engine to fix it and find ...
    (alt.med.fibromyalgia)
  • RE: VLookup - finding wrong value
    ... First -- how vlookup works. ... That should fix the problem. ... is before noon time it returns the wrong value Anything after 12PM is ... On a seperate sheet an operator enters another time into cell B5, ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Sporadic Enter Network Password
    ... end of my original post). ... What is crazy is that it isn't ALL the time, ... the same ISP - and I only get the messages on one of them, ... I have tried to fix by deleting/reinstating the e-mail account, ...
    (microsoft.public.outlook.general)
  • Re: Mud Gaurds
    ... caliper brake mounting hole through he bridge and will be flexing those stays like crazy if you try and fix them to the fork legs which move up and down. ...
    (uk.rec.cycling)