Thanks for offering to help, Valko.
No, I have 2 primary & 1 dependent (or maybe the right way to look at it is
1 primary & 2 dependent). The 1st primary is B1, the 1st dependent is B2, and
the 2nd dependent is B3.



"T. Valko" wrote:

Do you have just 1 primary drop down and 1 dependent drop down? If so, what
cells are they in?

--
Biff
Microsoft Excel MVP


"Ian Elliott" wrote in message
...
Thanks for any help.
Using http://contextures.com/xlDataVal02.html, I have a data validation
dependent on another data validation. So when I change the original data
validation, and then change the dependent data validation, I only get a
choice based upon the original data validation. However, before I choose
for
the dependent data validation, if I had a previous choice that wasn't
possible, that value will still remain, even if I choose the original data
validation something that won't have that dependent value. Is there a way
to
blank out the dependent if it won't be allowed?
Sorry if that's confusing.