Assigning values to words, then referencing them in a formula
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,
|