Quote:
Originally Posted by tman_88
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?
|
HELP from BRAZIL <<<
Dear Tman_88, Good Afternoon.
I suggest you to use Data Validation creating some Dependent Lists.
At almost all cases it´s simple to apply this.
Take a look at: H:\planilhas\Excel Data Validation -...With INDEX.htm
Have a nice day.
__________________
I hope it can help you.
Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
|