Excel Dependent Drop-down Lists - Easy Excel Tutorial http://www.excel-easy.com/examples/dependent-drop-down-lists.
html
Excel Easy
#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us
Dependent Drop-down Lists
This example describes how to create dependent drop-down lists in Excel. Here's what we are trying to achieve:
Chapter
The user selects Pizza from a drop-down list.
Data Validation
Learn more, it's easy
Reject Invalid Dates
Budget Limit
As a result, a second drop-down list contains the Pizza items.
Prevent Duplicate Entries
Product Codes
Drop-down List
Dependent Drop-down Lists
Download Excel File
dependent-drop-down-lists.xls
Follow Excel Easy
1 of 5 08-11 05:36 PM
Excel Dependent Drop-down Lists - Easy Excel Tutorial http://www.excel-easy.com/examples/dependent-drop-down-lists.html
To create these dependent drop-down lists, execute the following steps.
1. On the second sheet, create the following named ranges.
Name Range Address
Food A1:A3
Pizza B1:B4
Pancakes C1:C2
Chinese D1:D3
2. On the first sheet, select cell B1.
3. On the Data tab, click Data Validation.
2 of 5 08-11 05:36 PM
Excel Dependent Drop-down Lists - Easy Excel Tutorial http://www.excel-easy.com/examples/dependent-drop-down-lists.html
The 'Data Validation' dialog box appears.
4. In the Allow box, click List.
5. Click in the Source box and type =Food.
6. Click OK.
Result:
3 of 5 08-11 05:36 PM
Excel Dependent Drop-down Lists - Easy Excel Tutorial http://www.excel-easy.com/examples/dependent-drop-down-lists.html
7. Next, select cell E1.
8. In the Allow box, click List.
9. Click in the Source box and type =INDIRECT($B$1).
10. Click OK.
Result:
Explanation: the INDIRECT function returns the reference specified by a text string. For example, the user selects
Chinese from the first drop-down list. =INDIRECT($B$1) returns the Chinese reference. As a result, the second
drop-down lists contains the Chinese items.
4 of 5 08-11 05:36 PM
Excel Dependent Drop-down Lists - Easy Excel Tutorial http://www.excel-easy.com/examples/dependent-drop-down-lists.html
Start Download
1) Click to Begin 2) Download App 3) Get 100s of Free Books & Readers
niit
Monthly Investment Plan
Class 1-10 GK Questions
HDFC Home Loan upto 30yrs
Vodafone Diwali Offer
Watch Free Videos
Salary & Payroll Software
Looking for Answers?
Free IT Training
Do you like this free website? Please follow us on Google+
Learn more about data validation, use the side menu >>
Go to Top: Dependent Drop-down Lists | Go to Next Chapter: Keyboard Shortcuts
COPYRIGHT (C) 2010-2015 WWW.EXCEL-EASY.COM. ALL RIGHTS RESERVED.
EXCEL 2010 TUTORIAL | HOW TO EXCEL | MICROSOFT EXCEL 2010 | EXCEL MACRO
5 of 5 08-11 05:36 PM
