View Single Post
  #1   Report Post  
tman_88 tman_88 is offline
Junior Member
 
Posts: 2
Default 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?