Hi ,
I have three columns like
Inside/Out side Fixture description replace fixture
Inside here is drop down list of fixture This column gives you the drop down depending upon the column fixture description from another sheet by VLOOKUP.
Suppose replace fixture has following drop down:
High bay fixture
4' LED fixture
Flood Light 20 W
Canopy Light 45W
Now I want to see the drop down of only those which does not have Flood and Canopy if the Inside/Out side ='Inside' and if out side the drop down of only those which does not have High bay.
Please Help..
I have three columns like
Inside/Out side Fixture description replace fixture
Inside here is drop down list of fixture This column gives you the drop down depending upon the column fixture description from another sheet by VLOOKUP.
Suppose replace fixture has following drop down:
High bay fixture
4' LED fixture
Flood Light 20 W
Canopy Light 45W
Now I want to see the drop down of only those which does not have Flood and Canopy if the Inside/Out side ='Inside' and if out side the drop down of only those which does not have High bay.
Please Help..