About Us

Dando265

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dependant Lists Question	ALEX	Excel Worksheet Functions	5	February 6th 07 03:23 PM
3 way dependant lists	stratmyster	Excel Worksheet Functions	3	July 24th 06 05:21 PM
Dependant Lists in Excel	Browett	Excel Worksheet Functions	2	July 14th 06 04:49 AM
dependant combobox list	L Sholes	New Users to Excel	1	April 10th 06 11:29 AM
Dependant Lists	Steve Bladon	Excel Discussion (Misc queries)	2	June 13th 05 12:28 PM

Menu

About Us