Excel Data Valadation using If/Then Statement

[cariengon]

I'm trying to use the data valadation in Excel, where I want the lists to be different based on the value returned in cell B40. I have named the lists "PRE_TREATMENT_OPT" and "POST_TREATMENT_OPT".

Below is the statement that I wrote, that is erroring out on me:

=if(B40="Pre-petition",[PRE_TREATMENT_OPT],if(B40="Post-Petition",[POST_TREATMENT_OPT],null))

I'm thinking it may be the way that I'm refering to the named range. Is my format incorrect? I'm sure I can use cell range references, but to keep my form clean, I'd rather reference a name.

Thanks!
Carie

 

[cariengon]

NEVER MIND! Figured it out. Took out the []'s and changed the null to "".

Thanks anyway!

 

[GrayShades]

Perhaps the best explanation I have ever found for dependent validation lists is here:

Aldain's Explanation of Dependent Lists

Software: XL2002 on Win2K
Humanware: Older than dirt

 

[GlennUK]

It was also covered pretty well in this thread ...

thread68-374286



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.