Hi,

I have a database

S = 5
UM = 4
MM = 3
LM = 2
J = 1

I have a list of people that i have ranked

A B
Jenny S
Max J

In Column C I would like the numerical equivalent of the letter ranking.
ie. Jenny is 5 and Max is 1

Is there a simpler approach than an embedded if statement? I have many more
ranks that I have list here and embedded ifs are not that practical.

Any help appreciated.

Thanks!