Multiple IF statements

[fishcakes]

I want to acheive the following…
- if you select "daily" in B2, the in B4, the Drop down / Data Validation selections will be Mon / Tue / Wed / Thu / Fri
- if you select "weekly" in B2, the in B4, the Drop down / Data Validation selections will be 1 / 2 / 3
- if you select "Monthly " in B2, the in B4, the Drop down / Data Validation selections will be M / Q

 

[Eric W]

Data Validation doesn't like arrays in its formulas, which makes making variable lists like this problematic. But it's pretty easy to create a formula on the spreadsheet to do it, then just refer DV to that formula, like this:

Book1
	A	B	C	D
1
2	Frequency	daily
3				Lists
4	Day			Mon
5				Tue
6				Wed
7				Thu
8				Fri
9
Sheet12

Cell Formulas
Range	Formula
D4:D8	D4	=SWITCH(B2,"Daily",{"Mon";"Tue";"Wed";"Thu";"Fri"},"Weekly",{1;2;3},"Monthly",{"M";"Q"})
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B4	List	=D4#

 

[fishcakes]

Excellent, you for both the quick and correct solution!

Eric W​

 

[Eric W]

Happy to help! Thanks for the feedback.