Replacing a number with a description in Excel

S

Steinbart

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.
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WORD VBA Search and switch to advanced ... 1
Removing a repeated words 0
Prompt For Replace in Selection And More... 0
Improving Macro That Keeps First Letter 0
Excel does not accept text format! 0
using find and replace it's making me look in another file to upd 1
Keep First Letters, with exceptions 0
Autonumber field in Excel that behaves the same as Access 0

Top