Cell Referece retreval

HI I am wondering if anyone can help. I have a list of players with scores I am sorting which player has the highest score and then using lookup to find the players name and other information. This works fine using large and then the position I want to find unless there are two players with the same points then the large finds the two figures the same but the look up picks the same one twice as it works on the points scored to find the player.
What I think I need to do is search the list using large then instead of getting the number from that cell retrieving the cell attribute and use that to locate the player information.

Example.
Table
A B C D
Points Player team points Last week.
10 Jim WWW 2
12 phill home or away 6
10 Mike dans men 3
15 mark www 8
22 john home or away 6

Results
Points Positoin Name
22 1 john
15 2 mark
12 3 phill
10 4 Jim
10 5 Jim

Code
Points Positoin Name
=LARGE($A$2:$A$6,G2) 1 =VLOOKUP(F2,A$2:D$6,2,FALSE)
=LARGE($A$2:$A$6,G3) 2 =VLOOKUP(F3,A$2:D$6,2,FALSE)
=LARGE($A$2:$A$6,G4) 3 =VLOOKUP(F4,A$2:D$6,2,FALSE)
=LARGE($A$2:$A$6,G5) 4 =VLOOKUP(F5,A$2:D$6,2,FALSE)
=LARGE($A$2:$A$6,G6) 5 =VLOOKUP(F6,A$2:D$6,2,FALSE)


What I am looking for is to return from the =large code the row in which it found the Nth number for example the first one which found John with 22 point would return 6 as it is in row 6. I can then use this to find what is in the column and row I want with a simple =B6 as the names are always in column B.

I hope this is not to long winded as I have not posted to one of these forums before. Any help given will be appreciated.

It is a pain, However you can cheat a little.

http://www.excelforum.com/showthread...13#post1703213


If you add the row number divided by a large amount to each value, this will enable you to split the values from the large function and then return the 2 seperate people who have a tie

Hope this is a start, if not get back

Regards

Dav

Thhak yI think I can make this workl now.