Text to correspond to number?

[jennie1153]

What I am looking to create formula wise is that if I put a number into let's say Column B I want it to "auto fill" Column C with a certain text that corresponds to that particular number.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Example:
Column B.....Column C
813204597.....Red
813204598.....Blue
813204597.....Red
813204597.....Red
Etc.

Can this be done?

 

[jberwald]

You can do a VLookup. Set up a list of your numbers with corresponding text in, lets say, column J and K - starting in row 2:

column J........Column K
813204597.......Red
813204598.......Blue
813204599.......Green
813204600.......Yellow

With the numbers needing the corresponding text in Column B. Use this formula in C2:


=VLOOKUP(B2,$J$2$:$K$5,2)

 

[jennie1153]

So there's no other way besides the VLOOKUP? Problem I have with doing the VLOOKUP is that others will have access to this file and well to put it nicely I’m impressed they figured out how to open an excel document.. If anything were to "accidently" get changed in the VLOOKUP or if the drop down of choices is too much for them to handle all these entries would have to be redone. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Shame you can't just tell excel that if Column B equals "Said number" than make Column C "Said text" automatically<o></o>

 

[jberwald]

I believe you can up to 7 numbers. I have only used 3.

in C2: =IF(B2=813204597,"Red",IF(B2=813204598,"Blue",IF(B2=813204599,"Green")))

But what stops little fingers from messing that up too?