VLOOKUP()can help.

For example, make a table from A1 to B7:
a 1
b 2
c 3
d 4
e 5
f 6
g 7
and put =VLOOKUP(C1,A1:B7,2,TRUE) in D1.

Then in C1 put a letter and D1 will return the equivalent value

--
Gary's Student


"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.


--
Loriandme69
------------------------------------------------------------------------
Loriandme69's Profile: http://www.excelforum.com/member.php...o&userid=28971
View this thread: http://www.excelforum.com/showthread...hreadid=487034