How to add different text to one cell?

[tman_88]

For example. . .

I have created a drop down list in A1 that says A, B, C. Now I want cel
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 woul
like it to say "goodbye."

I know how to make this work using the IF function but I cant figure ou
how to add more than one answer.

Any ideas

 

[Claus Busch]

Hi,

Am Wed, 25 Apr 2012 15:11:11 +0000 schrieb tman_88:

So if A1 is B, I would want it to say "hello" and if A1 said C, I would
like it to say "goodbye."

in A2 try:
=IF(A1="B","hello",IF(A1="C","goodbye",""))


Regards
Claus Busch

 

[Mazzaropi]

Mazzaropi,
Not sure what that link is but it doesn't get me anywhere. Im also no
sure what you mean by a dependent list?
Thanks

Dear *Tman_88*, Good Evening.

Sorry about the link. It was my fault.
Link Ok now:http://www.contextures.com/xlDataVal02.html

You said:-"I know how to make this work using the IF function but I can
figure out how to add more than one answer"-

Dependent list is the way to add more than one answer DEPENDING to th
previous choice thru your validation box.

If you send your worksheet it will be very easier to understand you
doubt

I´m waiting to receive your worksheet