software

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

It sounds like you need Dependent Lists.

Check out Debra Dalgleish's Contextures website:

www.contextures.com/xlDataVal02.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;SianHquot; wrote:

gt; Hi,
gt;
gt; I wonder if anyone can help. I'm trying to use a named list in an IF
gt; statement ... or perhaps someone can point me to a different way.
gt;
gt; Basically, I want someone to select a value in one particular cell. There
gt; are 3 values to pick from. Based upon their selection, a different cell will
gt; then produce a specific list of values that they can select from.
gt;
gt; Any ideas on how I can do this?
gt;
gt; Thank you!
gt;
gt; Sian


Thank you SOOOO much Ron!!! Works like a dream!!

Sian

quot;Ron Coderrequot; wrote:

gt; It sounds like you need Dependent Lists.
gt;
gt; Check out Debra Dalgleish's Contextures website:
gt;
gt; www.contextures.com/xlDataVal02.html
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;SianHquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I wonder if anyone can help. I'm trying to use a named list in an IF
gt; gt; statement ... or perhaps someone can point me to a different way.
gt; gt;
gt; gt; Basically, I want someone to select a value in one particular cell. There
gt; gt; are 3 values to pick from. Based upon their selection, a different cell will
gt; gt; then produce a specific list of values that they can select from.
gt; gt;
gt; gt; Any ideas on how I can do this?
gt; gt;
gt; gt; Thank you!
gt; gt;
gt; gt; Sian