If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
lookup database
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! |
#3
|
|||
|
|||
lookup database
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! |
#4
|
|||
|
|||
lookup database
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 - |
Thread Tools | |
Display Modes | |
|
|