Other option than IF function

[rburk]

I have one cell on the left, let's say B2, which can hold any of 23 different symbols -- let's say "A" or "B" or "C" etc., all the way through "W." Then, I have one cell on the right, let's say C2, which I'd like to be a numerical value, based on the symbol that is entered into B2.
So, let's say "A" in B2 should create a value of "1" in C2; "B" in B2 should create a value of "2" in "C2", etc.
How do I do this?
I've tried =IF(B2="A",1,IF(B2="B",2,IF(B2="C",3,etc.))), but the IF function only allows 7 alternatives, and I need 23.
Any ideas?
Thanks in advance!

[pike]

Hi rburk
Welcome to the forum
one way is with Lookup

Please Login or Register  to view this content.

[col12345]

Hi as well

=code(B1)-96

will work also

[Cutter]

I think you mean:

=CODE(B2)-64

[ChemistB]

I think the OP was only using letters as an example. Lookup will work, or you can set up a table Code in Col 1 and expected return in col 2. You can use a Defined name or refer to the table directly. So if the table (minus headings) is in F2:G24

= VLOOKUP(B2, $F$2:$G$24,2,FALSE) will return your numerical value

Does that work for you?