Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Data validation example

0

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.

Answer
Discuss

Answers

1

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

Discuss

Discussion

Hi , i know this solution. But I'm looking WITHOUT any helper table or additional column, if it is possible. 
Thank you
Gargamel (rep: 2) Jun 27, '21 at 2:59 am
Gargamel

I've revised my answer to give you anothe clue but I won't do your homework for you, sorry.
John_Ru (rep: 6102) Jun 27, '21 at 9:54 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login