# giving points by a result (function)

1. ## giving points by a result (function)

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 ?

2. ## RE: giving points by a result (function)

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

--
Regards,
Dave

"Perttu O." wrote:

> 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 ?
>
>
>

3. ## Re: giving points by a result (function)

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

"David Billigmeier" <DavidBilligmeier@discussions.microsoft.com> wrote in
message news:92D82D83-A503-45AC-B6FE-E80A7863BF49@microsoft.com...
> Have a look at VLOOKUP() in the help menu.
>
> --
> Regards,
> Dave
>
>
> "Perttu O." wrote:
>
>> 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 ?
>>
>>
>>