| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Assign values to text within a cell
I would like to know which single function I should use to assign a number
value to a chosen set of words within a cell and place the value in another cell ie: if worksheet1,c4 is equal to "High" then worksheet2,d17 will be 3, or if worksheet1,c4 is equal to "Medium" then worksheet2,d17 will be 2, or if worksheet1,c4 is equal to "Low" then worksheet2,d17 will be 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reference a text cell that changes weekly in Header or Foo. | Excel Discussion (Misc queries) | |||
| On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
| Text is not showing up in cell. Why not? | Excel Discussion (Misc queries) | |||
| Text in cell as Formula | Excel Discussion (Misc queries) | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
Threaded Mode
