letter to number formulas

[wildomac]

hi,

I'm having trouble finding a way to formulate a cell so when
colleague enters a Letter a specifiic cell would display a number valu
relating to that letter.

For example is the Letter M = 5, then when a colleague enters a M i
say A1, a number 5 would automatical be added to A2

I hope I'm clear enough!!!

Cheer

 

[Frank Kabel]

Hi
as a starting point have a look at VLOOKUP together with a lookup
table:
http://www.contextures.com/xlFunctions02.html

 

[Petrus Van den Cruyce]

Where can i find the value off de letters where do you write that for M
the value must be 5? Is it in a table or in rows or colums?

 

[Art]

Another possibility, if the corresonding numbers are sequential, is to use
the Code function -- this will convert a letter to its ASCII value which you
could then adjust.

Art

 

[wildomac]

Thanks for the replies guy, I think the Vlookup is the one I'm lookin
for. I'll try them out tonight and see.

thanks agai

 

[Gord Dibben]

Petrus

Basic example.

Letters in column A

Coresponding numbers in column B

In column C at C1 enter =VLOOKUP(D1,A1:B26,2,False)

When enter a letter in D1, a number will appear in C1

For refinements, you can have the letters and numbers columns on another
sheet.

You can name that list and use the name instead of the A1:B26

You could have a Data Validation drop-down in D1 for selecting the letter.

For more on VLOOKUP and Data Validation see Debra Dalgelish's site.

DV....... http://www.contextures.on.ca/xlDataVal01.html

VL....... http://www.contextures.on.ca/xlFunctions02.html

Gord Dibben Excel MVP