+ Reply to Thread
Results 1 to 3 of 3

Another VLOOKUP TRUE issue...

  1. #1
    Registered User
    Join Date
    01-28-2013
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    9

    Another VLOOKUP TRUE issue...

    Maybe I've got too much going on in this thing, I'm not sure. I've spent the last week trying to get to know the functions I've used in my tracker, indirect is new to me but it isn't what is giving me problems. Only today I've discovered vlookup has been reporting the wrong scores here. When I went back and looked at the original calculator I've based all of my work on did I realize that it was also giving erroneuos scores. Then after numerous google searches did I find how limited the TRUE in vlookup is, and multiple recommendations to switch to an index/match formula instead. And that is where I am completely lost. I made a couple attempts and failed. I really wish there was a way to make true always round up but I couldn't find anything. Attached is a sample workbook. Just look at the run scores. those are the only things relevant with this issue.

    The run scores are simple. a point is added at every 6 second interval. based on the age/*** and run time a score is determined. 19 year old male runs a 1554(this is how 15 minutes 54 seconds is represented in the tables) he gets 60 points. anywhere from 1555 to 1600 is 59 points, which makes the run a fail(any score in any category below 60 produces "fail." but as I've shown on the worksheet, these scores between 1554 and 1559 are producing a 60 and as a result a "pass." which is unacceptable.

    I need fresher eyes and smarter minds.

    vlookuptrueproblem.xlsx

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Another VLOOKUP TRUE issue...

    Hi, I thought your question looked familiar

    http://www.excelforum.com/excel-form...le-errors.html

    I will take a look and get back to you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Another VLOOKUP TRUE issue...

    looking at your table for male runners, you have...

    1542 =63
    1548 =61
    1554 =60
    1600 =59
    1606 =57
    and you are looking up
    these scores between 1554 and 1559 are producing a 60 and as a result a "pass." which is unacceptable.
    Your table only drops to 59 (fail) at 1600 - your values are faster than that?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1