Excel 2007 : Convert a letter to a number

**CamnJane** · 10-25-2011, 09:33 PM

Hi there, really sorry if this is a basic newbie question which I am sure it is! I have surfed through the threads so far and done a bit of Googling but am still lost. I am getting stuck between, VLOOKUPs, If - then- and also the Substitute option but really have no idea

On a sheet I have several cells containing a drop down box with the options of E,H,G,L

I would then like to use a formula which will take that value and convert it to a number in another cell in the next column or so over so I might create a graph from the numerical values.

EG: a selection of E in the drop down would put a 10 in another cell, a selection of H in the drop down would put an 8 in another cell, a selection of G in the drop down would put a 6 in another cell and a selection of L in the drop down would put a 3 in another cell.

Sorry to break it down so much for all you experts but I am trying to hit a deadline and am starting to get desperate as I can't nut this out to complete my work! Any help would be greatly appreciated!
Cam

**protonLeah** · 10-25-2011, 10:38 PM

Your explanation is very vague. You said "... On a sheet I have several cells ..."

Then you said:
"...a selection of E in the drop down would put a 10 in another cell, a selection of H in the drop down would put an 8 in another cell..."

Hum?? "... another cell..." Does that mean that the "other cell" depends on the value selected from the dropdown?? Hopefully, you meant the same cell but different values in that cell based on the dropdown choice.

Now, working with the vagueness, say your dropdown is in A1 and you want the value in "... another cell ..."

to reflect A1. Then in
... that other cell ...
put something like:

Please Login or Register  to view this content.

P.S. sample workbooks help so much ......

**Marcol** · 10-25-2011, 10:50 PM

See if this workbook is on the lines you are thinking.

**MarvinP** · 10-25-2011, 10:52 PM

Hi Cam and welcome to the forum.

You could also create a VLookup Table with the letters and the numbers next to them. Use this table to return the numbers for the letters.
See the attached for the example.