lookup database

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!

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" wrote:

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!

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?

"Raz" wrote:

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" wrote:

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!

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

On Oct 13, 8:29*am, ellebelle
wrote:
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?



"Raz" wrote:
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" wrote:

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!- Hide quoted text -

- Show quoted text -