Validation List

[The Todal]

I'm trying (without success) to figure out how to make the validation list in B1 subject to the item selected in A1. Any suggestions? TIA

 

[ADAMC]

Can you expand on what you want? you want the list in B1 to contain the data of A1?.....

 

[Matty]

If I've understood correctly, I think what you're after is described well at the following site:

http://www.contextures.com/xlDataVal02.html

Matty

 

[Derek Brown]

The item selected in A1 needs to refer to a 'named range' (sometimes also referred to as a 'named formula'. For example, the Data Validation needs to ALLOW a list with the SOURCE set as
List1,List2
that refer to two named ranges already created (no spaces of course).

The cell validation for B1 needs to ALLOW "List" with the SOURCE set to =INDIRECT(A1)

 

[dave3009]

Hi There

If you had a helper sheet you could use VLOOKUP in series to give you your results.

If you have space for a helper sheet let me know

HTH


Dave

 

[The Todal]

I have a list of 6 items that can be selected from a validation list in cell A1. Here are the options for A1: Air Compressor,Air Stripper,Catox,MPX Blower,SVE Blower,Thermox.

If I select "Air Compressor" in A1, I want the validation list in B1 to be: Rotary screw, Vane, Claw, Regenerative

If I select "Air Stripper" in A1, I want the validation list in B1 to be: Tray, Tower, Diffuser.

and so for the other 4 A1 options.

 

[dave3009]

Not a problem, let me get Colo's HTML Maker and I'll show you exactly how to do it.

I assume you have space for a helper sheet

 

[dave3009]

Hi There

Here is a basic example

Book1
	A	B	C	D	E	F	G	H	I
1
2
3
4		Rep1	a	b	c	d	e
5		Rep2	f	g	h	i	j
6		Rep3	k	l	m	n	o
7		Rep4	p	q	r	s	t
8
9
10
11
12		2	a
13		3	b
14		4	c
15		5	d
16		6	e
17
18
19	Rep1	a
20
Sheet1

 

[dave3009]

Cell A19 is a vaildation list set to cells B4:B7. Then you have a set of VLOOKUP's (the 2, 3, 4, 5, 6 is the distance in the range I want to look).

When the cell A19 is changed you will see the single letters down there change.

Your Air Compresser, Air Stripper is where I have Rep1 etc and where I have single letters you have your sub category.

The cell B19 is a vaildation list set to C12:C16

Hope it Helps


Dave

 

[The Todal]

Thanks for all your help, Dave. I'll give that a try. Did you get out to Carnoustie for The Open this weekend?