Create 2 Dependent List.

[hecgroups]

Hello,

I am trying to create a dependent list of dependent list.

Ex:

First List Dependent List 2 Dependent List
Movies English Action
Hindi Romance

Let say if i select Movies then English it should list second dependent list based on first dependent list.

can it be possible.

[Fotis1991]

Hi

If i get your point, the answer is YES. We can do dependent list based on first dependent list.

To be clear fo ell. pls upload a sample workbook.

[hecgroups]

Thanks for reply,

Sample list is attached.

I have to make difference selection depending on my original data. If i get idea the i can do so.

So, the requirement is if select providers then signed. The 2nd dependent list should display the items in columns C ad drop down list.

[Fotis1991]

..You mean that if the user select in B2, the word "Signed", then in B2,you want to appear the list that you have now in Column C?? Or you want this list In C2?

[hecgroups]

i want to select Providers fin A2 then i will select Signed or not signed or followup in B2 then depending on B2 list i will select C2 items which is Central, Eastern, etc... then so on....

If you get me the second dependent list i will study and make the list as i want.

[Fotis1991]

...Why don't you use INDIRECT, as in B2??

[hecgroups]

Got the idea. It means i can create the list under list and named as i want the use indirect function.