+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Help with vlookup/hlookup

  1. #1
    Registered User
    Join Date
    08-15-2009
    Location
    edinburgh
    MS-Off Ver
    Excel 2007
    Posts
    4

    Help with vlookup/hlookup

    Wonder if anyone can help. I run a football prediction league at work (10 games 3 points for a correct score 1 point if correct result) this will run for the season with a league running for person with most points my problem is i would like the league to auto update when i put results in. ive got as far as doing vlookup/hlookup but if two people have the same points it only shows the person with those points if two people have the same points then i would like the person with the most correct scores to be next in the league and if they are still the same then the person with the most correct results and if thats still the same then just alphabetical in order of name can someone point me in the right direction. Ive attached the full file if someone can help

    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Help with vlookup/hlookup

    have a look here
    http://www.cpearson.com/excel/Rank.aspx
    scroll down to
    Double Ranking And Tie Breaking
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ 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