Validation List

The Todal

Board Regular
Joined
Jan 2, 2007
Messages
129
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
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Can you expand on what you want? you want the list in B1 to contain the data of A1?.....
 
Upvote 0
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)
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
Hi There

Here is a basic example
Book1
ABCDEFGHI
1
2
3
4Rep1abcde
5Rep2fghij
6Rep3klmno
7Rep4pqrst
8
9
10
11
122a
133b
144c
155d
166e
17
18
19Rep1a
20
Sheet1
 
Upvote 0
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
 
Upvote 0
Thanks for all your help, Dave. I'll give that a try. Did you get out to Carnoustie for The Open this weekend?
 
Upvote 0

Forum statistics

Threads
1,218,740
Messages
6,144,215
Members
450,531
Latest member
avril18

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top