Indirect Formula Error

[decent_boy]

Hi
I am using indirect formula for dependent drop down list in mentioned below data

Dependent-Drop-Down-List-Excel_v2.xlsx
	A	B	C	D	E	F	G
1	Fruits	Vegetables
2	Mango	Potato		Drop Down 1	Drop Down 2		Formula
3	Apple	Tomato		Vegetables	Tomato		Tomato
4	Grapes	Spinach
5	Strawberry	Onion
6	Kiwi	Cucumber
Dependent Drop Down

Cell Formulas
Range	Formula
G3	G3	=INDIRECT($D3)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E3	Expression	=ISERROR(VLOOKUP(E3,INDEX($A$2:$B$6,,MATCH(D3,$A$1:$B$1)),1,0))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
D3	List	=$A$1:$B$1
E3	List	=INDIRECT($D$3)

But When I change vegetable name to Alan indirect function show error and does not work, can anybody help me on this

Dependent-Drop-Down-List-Excel_v2.xlsx
	A	B	C	D	E	F	G
1	Fruits	Alan
2	Mango	Potato		Drop Down 1	Drop Down 2		Formula
3	Apple	Tomato		Alan			#REF!
4	Grapes	Spinach
5	Strawberry	Onion
6	Kiwi	Cucumber
Dependent Drop Down

Cell Formulas
Range	Formula
G3	G3	=INDIRECT($D3)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E3	Expression	=ISERROR(VLOOKUP(E3,INDEX($A$2:$B$6,,MATCH(D3,$A$1:$B$1)),1,0))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
D3	List	=$A$1:$B$1
E3	List	=INDIRECT($D$3)

 

[Fluff]

Glad we could help & thanks for the feedback.