IF statements with lists

S

SianH

Hi,

I wonder if anyone can help. I'm trying to use a named list in an IF
statement ... or perhaps someone can point me to a different way.

Basically, I want someone to select a value in one particular cell. There
are 3 values to pick from. Based upon their selection, a different cell will
then produce a specific list of values that they can select from.

Any ideas on how I can do this?

Thank you!

Sian
 
Top