I tried this but it didn't let me enter the validation formula if C7
evaluated to False. The error was: "The list source must be a delimited
list, or reference to single row or column".

Enters fine when C7 evaluates to True.

I like this one the best.

--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"T. Valko" wrote in message
...
=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 !!!