Is this possible?

  • Thread starter Thread starter jeny04
  • Start date Start date
J

jeny04

I'm working on an admissions spreadsheet and wanted to know if it is possible
to convert a letter to a number in a different cell? Like:

Cell B4= A
I want cell B5 to be 12 (A=12)

Is there any function that does such a thing?
 
jeny04 said:
I'm working on an admissions spreadsheet and wanted to know if it is possible
to convert a letter to a number in a different cell? Like:

Cell B4= A
I want cell B5 to be 12 (A=12)

Is there any function that does such a thing?
Click to expand...

VLOOKUP should do the trick. See Excel help for this function.

Bill
 
Yes sure. Create a table somewhere with letters in a column and the
corresponding number in the neighbor column to the right. Then create a
VLOOKUP formula in B5 that looks up the B4 letter in the table.
Without knowing your logic ("A=12, and so on") it is hard to be more
spesific, but see Help on VLOOKUP.


HTH. Best wishes Harald
 
Another possible solution if you need to make more than just the one decision:

=CHOOSE(FIND(B4,"ABCDEFGHI"),12,13,14,15,16,17,18,19,20)
 
Tell us all the letters and their numerical equivalents... perhaps there is
a simple mathematical expression relating the two.
 
Back
Top