Replacing a number with a description in Excel
 

I want to enter a number into a cell and have it replaced with a description.
i.e. If I enter "1" in a cell it will replace it with "frame." If I enter
"2" it will replace it with "carpet." I need an excel fromula to tell the
program to do this.

There are no formulas that will do that, only VBA
You can however use a vlookup table and get the desciption in the adjacent
cell,
in either way you need to make a list of all replacement/descriptions and
their numbers

Regards,

Peo Sjoblom

"Steinbart" wrote:

I want to enter a number into a cell and have it replaced with a description.
i.e. If I enter "1" in a cell it will replace it with "frame." If I enter
"2" it will replace it with "carpet." I need an excel fromula to tell the
program to do this.

Hi
you may use VLOOKUP in an adjacent cell if you don't want to use an
event procedure. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Steinbart" schrieb im
Newsbeitrag ...
I want to enter a number into a cell and have it replaced with a
description.
i.e. If I enter "1" in a cell it will replace it with "frame." If I
enter
"2" it will replace it with "carpet." I need an excel fromula to
tell the
program to do this.