Hi ,
I need a data validation depedent drop down list. Without any table or helper column. And nly with formula not vba codes.
Thank you for your help.
A attached a file and explain details.
Hi ,
I need a data validation depedent drop down list. Without any table or helper column. And nly with formula not vba codes.
Thank you for your help.
A attached a file and explain details.
Gargamel
Please see the Data Validation section under Tutorials e.g. Automatically Updating Dependent Drop Down List Menus in Excel and work to solve your homework question.
You'll also find two possible solutions under this recent Forum question function indirect doesn't work with data validation