I would like to create an excel formula that could help me “allocate” a value to an alphabet.
Say for an example,
I create a table
|A|4| which means (A=4)
|B|3| which means (B=3)
|C|2| which means (C=2)
|D|1| which means (D=1)
and I have a whole lot of data entered into (say for example) column A, with alphabets of random (A,B,C and D).
I would then like to use the cells in column B to translate these alphabets to an allocated numerical value (as shown above).
What would be the solution?
I hope to hear from you soon! Thanks!
P.S You can use any form of formula(not limitting to creating a table specifically to allocate the numerical value. (i.e. create a formula that may or may not refer/look-up to the table above)
By: Marcus Benedict