pick up from list depending on another list value picked

A

Anamika

Hi,

I have 3 values say A,B,C in Cell C1 in a List (Cell drop down). I hav
another list in Cell C2 with values D,E,F (Cell drop down).

I want only values D and E to drop down when I pick A or B and values
and F to drop down when I pick C.

How can I do this through Excel
 

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

Drop down list control value in vba 2
Copy and Paste Word 2010 0
Automatically populate value of cell dependent on adajecent cell 3
Formula for looking up and copying from another worksheet? 1
Limit drop down items based on another cell 3
Formatting Rule: Diplay Section based on Selection in another section 0
Data Validation and drop-down list using IF, AND and what else? 8
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1

Top