List validation - Dependent on Other lists

[weegieavlover]

Hi All,

Hope you can help me with my problem. I have a workbook that has about 4 lists on it and all should be dependent on the previous list. However they are not and are just general lists.

I have been searching google for my answer and I have come across some things but nothing that is specific to my problem.

Here we go:

List 1:
3055
0878
3066
1608
1570

I select these cells in the same column (eg Column A1 to A5) and use the name field to call them "array"

Now if we take "0878" as my example.

If this select it should give me:

List 2:
Disk_Group_2
Disk_Group_3
140GB
300GB

Again I select these cells in same column (eg Column B1 to B4) and use the name field to call them "0878".

if "Disk_Group_3" is selected it should give me:

List 3:
8714
17428
34856
69718

Again I select these cells in same column (eg Column C1 to C4) and use the name field to call them "Disk_Group_3".

Now if we use these 3 lists as my example.

I then go to Column F and select rows 1 to 10 (eg)
I then go to Data > Validation.
Select "List" under "allow"
In Source I use the formula
=array

I then go to Column G and select rows 1 to 10 (eg)
I then go to Data > Validation.
Select "List" under "allow"
In Source I use the formula
=INDIRECT(F1)

I then go to Column H and select rows 1 to 10 (eg)
I then go to Data > Validation.
Select "List" under "allow"
In Source I use the formula
=INDIRECT(G1)

Now when I go to:
F1 - I can select 0878
G1 - I can select Disk_Group_3

Problem when I go to H1 is I only get a list of the disk groups (list in column B) again.

I am not sure how to get this working and was hoping the above makes enough sense for someone to assist?

Thanks
Colin

 

[VoG]

This may help you http://www.contextures.com/xlDataVal02.html