Need to creat dependent drop down list

G

Guest

Dear Expert,

I am creating a reporting format in excel. I am finding it difficult to
make a drop down cells dependent on the other cell value.

e.g. In one column i already defined a drop down list of some stages. I
need one more drop down list in other column which will be dependent on the
selection of the text in first drop down list. How do i go about this. Is
there any solution in excel for this.

Rgds,
Manish
 
P

papou

Hi Manish
One of the tricks consists of naming the dependent lists using a defined
name with either a prefix or suffix identifying the previous choice made and
building the list using worksheet function INDIRECT.
eg:
1- Main List in A1:
CARS
MOTORBIKES
2 - Dependent List in A2
Data Validation, allow List, Source = INDIRECT(A2 & "LIST")

Dependent lists in some other part of your worksheet
CAR list - defined name = CARSLIST
MOTORBIKE list - defined name = MOTORBIKESLIST

HTH
Cordially
Pascal
 
P

papou

Ooops
In A2 formula in data validation, should read:
Source = INDIRECT(A1 & "LIST")

Apologies

Cordially
Pascal
 

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

Dependent drop down dynamic range formula, off sheet. 7
dependent drop down list 1
Multiple Dependent Drop Down 1
Drop Down with dynamic named range offsheet source list 14
Dependent drop-down list?? 4
Formatted cell column in drop down list 1
How do I change contents of a cell based on drop down list selecte 2
Data Validation - Conditional List 3

Top