letter to number formulas

  • Thread starter Thread starter wildomac
  • Start date Start date
W

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
 
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?
 
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
 
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
 
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
 
Back
Top