Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Lookup information in Access Database | Excel Discussion (Misc queries) | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Code to 'lookup' value in Access database | Excel Discussion (Misc queries) | |||
Database Lookup | Excel Worksheet Functions |