20 5 1 18 19 15 6 10
15 25





Tears of joy!



Can't thank you enough.



Best regrads,



Jim




"R1C1" wrote in message
...
Sorry James,

I did not type what my mind was thinking, lol. The formula goes in A2 not
B1.

A1 through Z1 are the entry cells, one letter entry per cell.
A2 through Z2 is the formula for the lookup of the table. (Not B1 as I
stated earlier)

Enter the formula in A2 and drag it across to match the number of entry
cells in Row 1.

AA1:AB26 is the lookup table range, CodeTable.

Regards,

Alan





"James E Middleton" wrote in message
...
R1C1

Very cool, does exactly what RagDyeR's code does but give me complete
control over the numbers is the code.

I teach English at in Japan and listening to numbers comparatively, or
being able to understand large numbers is key for their listening tests.
I'll be able t omake some fun activities easily with this.

I do have one question...

In my original post:

I don't mind formatting it after into something useable, however, if it
was possible:

In Row1 type the word or sentence, one letter in each cell, numbers
are output in Row2.

In your response, you mentioned creating a named range all the way over
in AA, AB, which I did.

The formula looks at column A, but you mentioned: 'Select B1, drag the
formula across the row as far as you want, as long as you don't pass
Column AA which is your table.'

So now, I can type the words or sentences down column A, and get the
output in column B.

Along with being able to define a number for each letter is the perfect
solution in itself.

I'm just curious if I misunderstood and there is a way to type in row 1
and get the code in row 2, instead of column A and B.

Thanks again.




"R1C1" wrote in message
...
Create a named range with your alphabet in one column and the numbering
in another column, say AA1:AA26 = A-Z and AB1:AB26 = 1-26. Highlight the
range (AA1:AB26), choose Insert, Name, Define, type in CodeTable in the
window, click Add, click OK.

In cell B1 enter the following formula:

=IF(ISNA(VLOOKUP(A1,CodeTable,2,FALSE)),"",VLOOKUP (A1,CodeTable,2,FALSE))

Select B1, drag the formula across the row as far as you want, as long
as you don't pass Column AA which is your table. You can create your
named range, CodeTable, anywhere you want of course.

Working with children, I would suggest unlocking all the entry cells in
Row 1, then protect the worksheet. This will allow the children to enter
in the cells you choose and the formulas for the lookup will remain in
tact.

Regards,

Alan




"James E Middleton" wrote in message
...
I am looking for an easy was to make a alphabet code game for my
students.

I want to give them words or sentences to 'decode'

For example; 2-1-3-11 = back

8-5 12-9-11-5-19 3-1-20-19. = He likes cats.

Something as simple as Col A 1-4: b,a,c,k outputs in Col B 1-4:
2,1,3,11

I don't mind formatting it after into something useable, however, if it
was possible:

In Row1 type the word or sentence, one letter in each cell, numbers are
output in Row2.

Thanks!

PS. if this can be done, is it possible to have the letters generate
any number as a code?

For example, a = 26, z = 1, or a = 10, b=20, etc