look in excel help at the vlookup function.


"Richard Travia" <Richard wrote in message
...
I have a set (approx. 30) of words that I have grouped into 4 categors and
can easily assign values to them (ie. 0, 1, 2, 3). I would like excel to
recognize the word, and automatically assign the value to it. How do I do
this? Please help.
Thank you,