alphabet as Numbers?
Ooopps! Backwards.
Go with the VLOOKUP table and switch the letters and numbers columns.
Enter a letter in C1.
Gord
On Mon, 21 Nov 2005 15:49:21 -0800, Gord Dibben <gorddibbATshawDOTca wrote:
In B1 enter this formula
=CHAR(A1 + 96)
Enter a number from 1 to 26 in A1
If numbers were not 1 through 26 you could use a VLOOKUP table.
Enter numbers in A1:A26
Enter letters a through z in Column B
In C1 enter a number
In D1 enter this formula =VLOOKUP(C1,$A$1:$B$26,2,FALSE)
Gord Dibben Excel MVP
On Mon, 21 Nov 2005 16:58:59 -0600, Loriandme69
wrote:
I want to associate letters of the alphabet with numbers so that when a
letter is put in a cell, a numerical value can be associated. Sort of
like a phone pad-I want it so that you could put the letter in a cell
and a designated number would automatiocaly show up in another cell. Is
there a way to create a formula that can do this? Help would be greatly
appreciated. Thank you.
|