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 -
|