Excel dropdown list

S

splashthecash

New Member
Joined
Jul 1, 2011
Messages
1
Hi,

Quick question for your all...I'm in work and I need help!

Is there anyway to have two dropdown lists related in that depending on what you select in the first one, only a certain set of options are displayed in the second dropdown?

Example

List 1
Premier League
La Liga
Seria A

List 2
Man Utd
Liverpool
Barcelona
Real Madrid
AC Milan
Inter Milan

If I select Premier League in the first dropdown, only Man Utd & Liverpool will available in the 2nd dropdown list. If La Liga is selected in the first dropdown, only Barcelona & Real Madrid are availble in the 2nd...etc....

Thanks!!
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

M
  • Question Question
How to track choices in a workbook from several drop down lists and reflect the running choices throughout the month
Replies
1
Views
444
bobaol
B
M
  • Question Question
VBA vs Formulas/Data Validation for Multiple Dependent Dropdown Lists
Replies
3
Views
2K
MissDB101
M
L
  • Question Question
Dependent/filtered data validation dropdown list not refreshing table filter to one record by slicer.
Replies
0
Views
234
LostInSwiss
L
L
  • Question Question
I'm crashing Excel with AutoFilter.Apply
Replies
1
Views
232
Anthony47
A
H
  • Question Question
Update One Sheet To Another
Replies
0
Views
230
honkin
H

Forum statistics

Threads
1,224,574
Messages
6,179,626
Members
452,933
Latest member
patv

Share this page

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