Simple formula

[thelenew]

I must be brain dead or something. I am just looking for a simple
formula to return a number. I have a key:
Example

a 121001
b 121002
c 121003
d 121004

Column "c" will have the a, b or c item, but I want column D to
autopopulate the number that corresponds to it.?
simple eh?

 

[Peo Sjoblom]

In D put

=CODE(C1)-96+121000

where C1 holds "a", copy down

so a formula might look like this

=IF(C1="","",CODE(C1)-96+121000)

then you can copy down in advance and when you put in the letter it will
return the number but when empty
it will stay blank