Display numerical code

C

catwoman

How do I make a phrase like "cherry bed" display as a numerical code like
"0042" once it is entered into the spreadsheet?
 
R

Ron Rosenfeld

How do I make a phrase like "cherry bed" display as a numerical code like
"0042" once it is entered into the spreadsheet?
Click to expand...

Construct a table with the equivalences, and use one of the LOOKUP functions.
--ron
 
C

CLR

This formula , if put in the next (or any) cell will display 0042 if a1
contains cherry red.........if you want the cell itself to convert over to
0042 when you type in cherry bed, that would take change-event
VBA...........

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

Lol............sorry, it was past my sleepy-time............thanks for
catching it Max........
here's the formula, depending on how it's spelled <g>

=IF(A1="cherry bed","0042","")

....and of course a VLOOKUP could be used instead if there were many
"phrases".

Merry Christmas to all............

Vaya con Dios,
Chuck, CABGx3
 
Top