Replacing a number with a description in Excel

Frank Kabel

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
how to increase maximum number of columns in excel 2003	[email protected]	Excel Discussion (Misc queries)	1	January 16th 05 08:13 PM
How to format a number in Indian style in Excel?	Victor_alb	Excel Discussion (Misc queries)	2	December 21st 04 04:21 AM
Can the number of times undo is used in Excel 2002 be increased?	Austrian Hannes	Setting up and Configuration of Excel	2	December 6th 04 05:54 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 05:45 AM.

Menu

About Us