Can you make an if statement that will choose a certain set of cells for dropdown lists if true and another set of cells for a dropdown lists if false? and how can you make an if statement create a dropdown list?
Say A1="Yes"
B1's drop down list will consist of:
Apple
Pear
Peach
these choices would be found in D1:D3
and if A1="No"
B1's drop down list will consist of
Pepper
Tomato
Cabbage
these choices would be found in E1:E3
Just wondering if this is possible
Bookmarks