Data Valididation using Dependent lists using Offset()

[bluegrassstateworker]

Hello,
I have a dependent list of 4 levels: Dept, Office, Division, Branch.
Each selection starting with department will provide lists based on
the previous selection. This is perfectly straightforward and
functions flawlessly. I am using named ranges and then using the
Offset function to obtain the proper list.

I would like to restrict options to a valid list in every
circumstance. My problem arises if there is no data in a previous
level and the user decides to type a value in where there is no list.
For example, level 1 (Dept) must be filled in with only the data --
that works fine in the validation sequence. However, if level 1 is
blank, the user can type anything in level 2 (office) and it is
accepted. Level 3 dropdown list will fail since it is dependent on
level 2. Not all entries have 4 levels; some only 3 levels.

Again, this all works fine if the user starts at level 1 then goes in
the proper sequence.

Any thoughts appreciated.

 

[Bob Phillips]

Untick the Ignore Blank option.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[bluegrassstateworker]

Untick the Ignore Blank option.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)









- Show quoted text -

That did it. Thanks.