=IF(c70,=$B$399:$B$400,"")

Try this:

=IF(C70,$B$399:$B$400)

Note that the drop arrow will still display but you won't be able to make a
selection if C70 = FALSE.

--
Biff
Microsoft Excel MVP


"lost and confused in excel-land"
. com wrote in message
...
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 !!!