numerology chart1

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

Fdibbins....
I posted two charts.
Chart1 was asking for formula to apply numbers to letters
Chart2 was asking how to determine only the vowels and consonants in each name
And then apply numbers

Re: your sample. Not clear to me, will work on it to see I can figure it out.

MRshorty...
Ooh migrated from lotus many many years ago and do not remember much of what I did then. Did not do such complex formulas in that day.

Thankyou for your help!

Ford,
I culd have sworn that I enervated two different requests one titled chart 1
And other chart2.

I culd not get to view chart2 to check if I was correct.

Will wait to see if I am successful with chart 1 request and then will re submit request for chart 2
Thnx

Am not getting this yet... Feel little dumb at this point! Tho once I get it, I will be on my way.
Mayb not explaining myself well.
I will create an example excel sheet and explain what I am trying to do.
Then will use advanced option and attach.
Need to work on that yet. Be back later!
Thnx

thank you all for your help!!
I am not very good at fully understanding the examples you have so kindly provided.

attached is a file which I hope will explain what i am trying to do.

all i would like is the forumula
example:

IF letter in one cell matches letter in column of table enter number at top
and so on until full name is complete

then
IF letter in one cell is vowel, a e i o u y
enter number at top of table

then
IF letter in once cell is consonant, alphabet minus vowels
enter number at top of table


I hope this is help you get a feel for what i want to do.
as you can see, it can be done manually
but would be so much easier to do via excel....if possible.

thanks

that is wonderful table....
however, what i am looking for is the actual formula to get those results.

oops...did a right click on cell and saw formula.
thanks so much.
will work on it in my excel sheet and hopefully i can get it working.

Wow incredible job ! Thank you very much, I was trying to do this as simple and efficient but without any success ! I will take your file as reference

thanks for your help guys

I have recently started dwelling more into numerology and wanted to create an excel with the formula and came across this page, since I have just joined in this forum, I am unable to download the files as yet. Hoping to be able to view the file to explore further.

Ya I'm getting a message that I do not have the permission on this forum to download the file as well.

Originally Posted by AliGW

It opens fine. No member is prohibited from downloading attachments.

sadly I can't open or d/l files.