Dependent data validation drop down list

August 31, 2011 at 09:19:13
Specs: Windows 7
Is it possible to create a data validation drop down list embedded in an IF() statement in MS Excel? What I want to do is this: create an if statement so that when a cell, say A1, has a certain content the cell with the If() statement will have that also. But if cell A1 is left blank, or has another content, the cell with the If() will have a drop down list. Any ideas? Thanks!

See More: Dependent data validation drop down list

Report •

#1
August 31, 2011 at 14:24:39
See this thread: That's about as close as you can get without using VBA code:

http://www.computing.net/answers/of...

By the way, a Dependent Data Validation Drop Down List is a specific kind of drop down and not exactly what you are trying to do. See here:

http://www.contextures.com/xldatava...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question