+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP putting all Names in order

  1. #1
    Registered User
    Join Date
    08-17-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    8

    VLOOKUP putting all Names in order

    Hello everyone,
    I need a little help with my spreadsheet. This is used for keeping track of a point’s series for RC racing. It is set up to track and auto sort the points and names of the racers to a separate sheet for printing. But what is happening is if two people have the same number of points the vlookup only puts the first person’s name in. So the question is what do I need to add in order for all of the names to be reported on the Standings sheet? I have attached the file.

    Thanks for all your help in advance.
    Todd Pearson
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: VLOOKUP putting all Names in order

    Hi Todd,

    Losi XXX-CR driver here, so your post immediately attracted my attention.
    I had a look at your spreadsheet, and added a helper column in the "Points" sheet between column W (Grand Total) and the Names column. The helper column (that you can hide if you wish) takes the points totals in column W, and adds 1/1000000 of the rownumber, so that all points totals become "unique". This allows the Vlookup to find the name of the second, third, etc name with equal points.
    I hope this solves your problem.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-17-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: VLOOKUP putting all Names in order

    Thanks for your help. That seams to work out great!

    Thanks agian and maybe well see you at the track some day!

    Todd Pearson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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