On 5 Jun, 20:44, Ron Coderre
wrote:
Try this:

I'll use only 2 manufacturers to save posting space...

With

Range Named: Mfg_List in F1:F3
(contains the mfg list: Craftwood, Lockwood, and Basswood)

Range Named: Craftwood_Louvre in G1:G10
(contains the Options)

Range Named: Craftwood_Frame in H1:H10
(contains the Options)

Range Named: Craftwood_Color in I1:I10
(contains the Options)

Range Named: Lockwood_Louvre in J1:J10
(contains the Options)

Range Named: Lockwood_Frame in K1:K10
(contains the Options)

Range Named: Lockwood_Color in L1:L10
(contains the Options)

Then....create these list-based DV cells:

A1: (contains DV List, based on Mfg_List)
B1: (contains DV List, based on =INDIRECT(A1&"_Louvre")
C1: (contains DV List, based on =INDIRECT(A1&"_Frame")
D1: (contains DV List, based on =INDIRECT(A1&"_Color")

Note: as you create each DV
...Excel may warn you that it currently evaluates to an error
...ignore the warning

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP



"Dando265" wrote:
Hi,
I'm stuck trying to create three dependant lists from a selction of
another list.

My Products are shutters made from different materials,(1st list)
Craftwood, Lockwood, and Basswood.

Each of these products have different louvre options (1st dependant
on
list1)
They also have diffent frame options (2nd list dependant on list1)
And finally they have different colours (3rd list dependant on list1)

Can anyone help me please, i'm really struggling with this.

Thanks

Dando265- Hide quoted text -

- Show quoted text -

Thanks Ron it worked a treat.

Dan