You would need a VBA macro to automatically translate what you type into
something else. If you are having problems with worksheet functions, macros
should probably be reserved for later, when you are more "fluent" with Excel.


On Wed, 11 Aug 2004 19:40:38 GMT, bronach wrote:

On Wed, 11 Aug 2004 18:58:09 +0100, kkknie wrote
(in message ):
If you mean you have a list of words/phrases and they each have
acorresponding number, you could just use a lookup table (i.e. using
theVLOOKUP() function). Search for VLOOKUP in the Help file and thatshould
get you started.

K---Message posted from http://www.ExcelForum.com/

thanks for the quick reply

hmm , not sure. what i want is to be able to type a bunch of numbers in one
sheet in different columns (representing nesting) and instead of the number
the word appears ... am i making myself clear? i had a look at vlookup, but i
can't undersatand it.

i think it might be right but the explanation of how VLOOKUP works only
confused me.

bronach