Simple formula

  • Thread starter Thread starter thelenew
  • Start date Start date
T

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