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