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?
|