lookup database

[ellebelle]

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!

 

[Raz]

just an IF functiion would do.
for example you have S or J etc. in A1
put this function in B1 (or where u like it)

=IF(A1=S,"5",if(A1=UM,"4",if(A1=MM,"3",IF(A1=LM,"2",1))))

 

[ellebelle]

Yes I could use an If Statement but this is a small example of a much larger
database. Is there a simpler approach than an if statement?

 

[Pete_UK]

Suppose your database is listed in Sheet1 in columns A and B like
this:

S 5
UM 4
MM 3
LM 2
J 1

and so on. Then if your names and rankings are in Sheet2, you can put
this formula in C1:

=VLOOKUP(B1,Sheet1!A:B,2,0)

and copy down as required.

Hope this helps.

Pete