| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assigning values to words, then referencing them in a formula
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting words and assigning a numeric value | Excel Worksheet Functions | |||
| Assigning words to a number | Excel Discussion (Misc queries) | |||
| assigning values to one cell which will change the formula in anot | Excel Worksheet Functions | |||
| formula to add values for all the same first words in cells in a r | Excel Worksheet Functions | |||
| Assigning values to words | Excel Discussion (Misc queries) | |||
Linear Mode
