Conditional Data Validation list

[spycein]

Hello everyone,
I have two name range lists as follows

Fruits

Orange

Apple

Banana

Coconut

Apricot

Vegetable

Cucumber

Eggplant

Pumpkin

Squash

Tomato

I am looking for a solution to use the above lists under data validation with if condition.

For example
If i Put date on or before 25/03/2020 in Cell A1 then in Cell B1 only Fruits name should show.
If i Put date on or after 26/03/2020 in Cell A1 then in Cell B1 only Vegetable name should show.

Hope i explained my query properly.
Best Regards,

 

[etaf]

in your data validation list use
=IF($A$1>=DATEVALUE("26/03/2020"), $I$1:$I$100,$J$1:$J$100)
this assumes the lists are in column I and J
I = vegetable List
J Fruits
Adjust these ranges to match your lists

lookup_indirect.xlsx
	D	E	F	G	H	I	J
1
2	5/26/20
3						a	1
4						b	2
5						c	3
6
7
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
E2	List	=IF($D$2>DATEVALUE("25/5/2020"), $I$3:$I$5,$J$3:$J$5)

 

[Fluff]

How about
=IF(A1<=DATEVALUE("25/03/2020"),Fruits,Vegetable)

 

[spycein]

How about
=IF(A1<=DATEVALUE("25/03/2020"),Fruits,Vegetable)

Thank you so much @Fluff..
Works like a charm.
Just wanted check if we can incorporate another if condition in the same formula, like if A1=blank then B1 = Blank
Many Thanks.
Best Regards,

 

[spycein]

in your data validation list use
=IF($A$1>=DATEVALUE("26/03/2020"), $I$1:$I$100,$J$1:$J$100)
this assumes the lists are in column I and J
I = vegetable List
J Fruits
Adjust these ranges to match your lists

lookup_indirect.xlsx
	D	E	F	G	H	I	J
1
2	5/26/20
3						a	1
4						b	2
5						c	3
6
7
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
E2	List	=IF($D$2>DATEVALUE("25/5/2020"), $I$3:$I$5,$J$3:$J$5)

Thank you so much for your help.
Best Regards,

 

[Fluff]

How about
=IF(A1="","",IF(A1<=DATEVALUE("25/03/2020"),Fruits,Vegetable))

 

[spycein]

How about
=IF(A1="","",IF(A1<=DATEVALUE("25/03/2020"),Fruits,Vegetable))

Thank you so much @Fluff for your instant help.
Exactly what i wanted.
Many Thanks.
Best Regards,

 

[Fluff]

Glad we could help & thanks for the feedback.