Formula Help

[Tykelad]

Is it possible for letters to have a value ?
E.G Imagine a blank cell. If i enter the letter M in it, i want the cell
next to it to show the number 8. If i enter the letter A, i want the adjacent
cell to show the number 11 etc etc
Can anyone help me ?

 

[Alan]

There are I suspect several ways, one would be to create a table in for
example Sheet 2 with column A containing 'A to Z' ,(A1:A26), column B
containing the values you want to assign to each letter (B1:B26)
Then if your blank cell were Sheet1A1, then in B1 enter :-
=VLOOKUP(A1,Sheet2!$A$1:$B$26,2,False)
Regards,

 

[Rodney]

G'day Tykelad,
Just a FYI
I cannot directly assist, as I am a plodder in Excel
however, In MSWorks I have a fields that use exactly your request
and I use a "Choose" statement.
The employment of this, depends on the number of characters
one can fit in a cell.
Otherwise VLookup is used.
Regards.




| Is it possible for letters to have a value ?
| E.G Imagine a blank cell. If i enter the letter M in it, i want the cell
| next to it to show the number 8. If i enter the letter A, i want the adjacent
| cell to show the number 11 etc etc
| Can anyone help me ?