| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to add different text to one cell?
For example. . .
I have created a drop down list in A1 that says A, B, C. Now I want cell A2 to show different content depending on what's in cell A1. So if A1 is B, I would want it to say "hello" and if A1 said C, I would like it to say "goodbye." I know how to make this work using the IF function but I cant figure out how to add more than one answer. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel cell to text file and text file to cell dir to cells and renamefile from cell | Excel Programming | |||
| Copy text from cell to cell with one cell changing text | Excel Worksheet Functions | |||
| Setting the text in a cell to the text of a cell on a different sheet in the same workbook | Excel Programming | |||
| select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... | Excel Programming | |||
| extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming | |||
Threaded Mode
