giving points by a result (function)

[Perttu O.]

is there a way to give points by a function ?

and in english, sport results (points) in excel sheet, let's say varying
from 10 to 100 and I would like to give them points from 10 down. meaning
that the best player (biggest points) would get 10 points, next biggest
points would get 9 and so on.

is there a formula or function to make this automatically ?

 

[Guest]

Have a look at VLOOKUP() in the help menu.

 

[Perttu O.]

I am little bit lost...

i know how to find largest, 2nd large etc, but how to make function that
looks up how largest players result is and looks up from the other chart to
give points

any help ?

player A B C D
results 19 10 48 5
points ? ? ? ?

--

result points
#1 5
#2 3
#3 2
#4 1