December 2016

example:

if:

"b", "k", "t" =2

"c", "l", "u" =3

"d", "m", "v" =4

"e", "n", "w" =5

"f", "o", "x" =6

"g", "p", "y" =7

"h", "q", "z" =8

"i", "r"=9

entering: m a r k

should return: 4 1 9 2

I have tried each letter of the name being in it's own cell and using "if, then, else" statements; "or" statements; and vlookup but continue to have trouble with the multiple (9) arguments.

I shall tell you one way how to do it

in A1 type

a

in A2 type

=CHAR(CODE(A1)+1)

copy A2 down till A26

you will get all the lower case alphabets

in B1 type 1 to 9 for alphabets a to i(cells B1 to B9)

highlight B1 to B9 and edit-copy

select B10 edit-paste

again select B19 edit-paste

Type

in four adjacent cells e.g A28 to D28

m a r k (each of the letters)

in A29 type this formula

=VLOOKUP(A28,$A$1:$B$26,2,FALSE)

copy A29 to B29,c29 and D29

you will get

Thanks to venkat1926 for this tip on the forum.

Related :

- Excel - - if then else with multiple criteria
- Excel: if then else with multiple criteria (Solved)
- Excel - Calculate the sum based on multiple criteria
- Excel - A Count if macro based on multiple criteria
- Excel - Conditional hide rows in multiple sheets
- Excel - How to insert rows when criteria is met?