I have a vlookup statement in cell c7 that returns a value based on a drop
down list in C6.

I have other dropdown lists below C6 (D6, E6, F6...) that allow various
choices. HOWEVER - they should not even appear if C7 returns a 0.

I wanted to put in an IF statement in the data validation for cells below C6
that say =IF(c70,=$B$399:$B$400,"") I keep getting an error. I think it
has something to do with the =

I tried:

=if(c70,vlookup($B$399:$B$400," ")) and it doesn't want to work either.


Many, MANY thanks !!!