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 ?