Assigning values to words

C

cardingtr

I have a drop down list of 7 phrases. How can I assign a value(1-7) on
each list so it will reflect to next cell?
Lets say the dropdown is in B2 and I want its value in C2.

Thanks.
 
D

DavidC

Hi,

If the phrases are standard and do not change, then use a simple "if"statement

If(B2="XXXX",1,if(b2="ÿyy",2,etc)

Hope this helps
regards
DavidC
 
G

Gary''s Student

=(B2="first")*1+(B2="second")*2+(B2="third")*3 and continue for as many as
you like
 
R

Ron Coderre

Try something like this:

For a text value (or blank) in A1
B1: =MATCH(A1&"",{"","aaa","bbb","ccc","ddd","eee","fff","ggg"},0)-1

Does that help?

Regards,
Ron
 
Top