i want to create a spreadsheet for calculating numerology numbers.
i used to be able to do this quite easily in the old LOTUS 123
but now cannot figure out how to do in excel

would enter letters of name each in its own cell
then relate each letter to a number......

if letter a,j or s in cell 1, then value is 1 else blank
if letter b,k, or t in cell 2, then value is 2 else blank
if letter c,l, or u in cell 3, then value is 3

if i can get these to work i can figure out rest of alphabet

hope someone could help.
thanks