IF statement with lists and dropdowns

M

malik641

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difficulty with compatibility mode and Track Changes 2
IF statement reference 1
Depedent Dropdown and INDIRECT($P$8) with a twist 4
Create two Data validation lists that are linked(Both change toget 2
Drop down lists and macros 3
Using Drop Down list to an If Statement to another Drop Down list 3
If statements in Data Validation 7
Multiple IF statements, macro stops at first True 0

Top