Dynamic dropdown

mac_see

Active Member
Joined
Oct 15, 2002
Messages
419
Book1
ABCDE
1Parameter1SubPara1_1
2SubPara1_2
3SubPara1_3
4SubPara1_4
5SubPara1_5
6
7Parameter2SubPara2_1
8SubPara2_2
9
10Parameter3SubPara3_1
11SubPara3_2
12SubPara3_3
13
14Parameter4SubPara4_1
15SubPara4_2
Sheet1


I have a dropdown box in cell A1 that has 4 values:
Parameter1
Parameter2
Parameter3
Parameter4

I want a dropdown in cell B1 which should be dynamic, it should depend on what is selected in cell A1. If user selects Parameter1, it should look up the corresponding sub-parameters from column E and put it in the dropdown list.

The above is sample data, I have more than 10 main parameters and sub parameters can be 2 to 25+

Maxi
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Thanx for your help Steve. I tried that example and I got an error which I have posted in that article.

Thank you once again
 
Upvote 0
.....D...................E..........
Parameter1......SubPara1_1
Parameter1......SubPara1_2
Parameter1......SubPara1_3
Parameter1......SubPara1_4
Parameter1......SubPara1_5

Parameter2......SubPara2_1
Parameter2......SubPara2_2

Parameter3......SubPara3_1
Parameter3......SubPara3_2
Parameter3......SubPara3_3

Parameter4......SubPara4_1
Parameter4......SubPara4_2

1. Try to fill up the Column D datas as above

2. Let cell A1 have a dropdown box of values: {Parameter1, Parameter2, Parameter3, Parameter4 }

3. Cell B1 >> Data Validation >> Choose : List and enter the following formula :
=OFFSET($E$1,MATCH($A1,$D:$D,)-1,,COUNTIF($D:$D,$A1))

Hope that helps
 
Upvote 0
I get the same error

The source currently evaluates to an error. Do you wish to continue?

I am using Excel XP
Microsoft Excel 2002 (10.6501.6626) SP3
 
Upvote 0

Forum statistics

Threads
1,196,328
Messages
6,014,670
Members
441,835
Latest member
rthomas268

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