Data Validation List (conditional)

U

User

I'm wondering if this is possible with a data validated list. I'd rather not use VBA code if at all possible.

Column-A represents a data validated drop-down list of 3 values: a,b,c

Column-B to be a conditional data validated drop-down list (right now 3 values maybe a few more in the future). If Column-A = "a" can Column-B present a drop down list of 1,2,3? For any other value in Column-A Column-B yields a blank cell or NA.

Column A Column B
a (select 1,2,3)
b NA
b NA
b NA
a (select 1,2,3)
b NA
a (select 1,2,3)
c NA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Cell Counter/Increment 2
A data validation question 1
Data Validation List 1
Conditional Validation In Excel 1
Need to create an excel template with many dependencies between columns and some prog 0
Sumif does not work 2
Comparing numbers 1

Top