L
lost and confused in excel-land
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(c7>0,=$B$399:$B$400,"") I keep getting an error. I think it
has something to do with the =
I tried:
=if(c7>0,vlookup($B$399:$B$400," ")) and it doesn't want to work either.
Many, MANY thanks !!!
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(c7>0,=$B$399:$B$400,"") I keep getting an error. I think it
has something to do with the =
I tried:
=if(c7>0,vlookup($B$399:$B$400," ")) and it doesn't want to work either.
Many, MANY thanks !!!