searching for a value and converting it to text

[lucy]

Does anyone know how to seach for a numeric value in a cell and if found convert it to a specific text value
For example:
Cell A:1 could have a numeric value between 1 and 5. I want Cell A:2 to read the numeric value and convert it to a text format: if 1 then GO, if 2, then STOP, if 3 then PAUSE, if 4 then RUN, if 5 then JUMP.

 

[lenze]

In A2 enter
=CHOOSE(A1,"GO","STOP","PAUSE","RUN","JUMP")

You may have up to 29 choices
This message was edited by lenze on 2002-11-06 14:01

 

[Mark W.]

Or...

=INDEX({"GO";"STOP";"PAUSE";"RUN";"JUMP"},A1)
This message was edited by Mark W. on 2002-11-06 14:28