Results 1 to 2 of 2

Excel 2007 : Help with vlookup/hlookup

Threaded View

  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

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