Dynamic DATA validation list

[Luigi802]

I want to make a dynamic DATA validation list that changes the list every time a cell changes it value, i.e. if A1="category" then make the drop down list tag name "categories," if A1="month" then make the drop down list tag name "months" etc... here's my formula which works great except for the amount list and description list, because they don't have a list per say, I want them to just be "any value" is there some kind of code I could put in place of the "Any value" that will allow me to type any vale in the drop down cell?

=IF($K$5="day",Days,IF($K$5="month",Months,IF($K$5="amount","Any Value",IF($K$5="description","Any Value",IF($K$5="category",Categories,IF($K$5="sub_category",Sub_Categories,IF($K$5="account",Accounts,"")))))))

 

[Roderick_E]

When setting up data validation turn off ERRORS, should allow a person to type over dropdown

 

[Luigi802]

When setting up data validation turn off ERRORS, should allow a person to type over dropdown

AWESOME! So simple, yet I never really looked at that in the options lol