Creating a Drop Down List with Dependant Values in Excel 2003/XP/2000/97.How to create a value dependant drop down list in MS Excel? |
Excel TemplatesBusiness TemplatesBudget TemplatesFinancial TemplatesCorporate Finance |
||||||||
Excel Tutorials & FAQsExcel FAQs |
Question: I am making an excel database. What I want to do is make a drop down list in Column B that is based (dependant) on value of Column A which has two or more possible values. For example, I have set the two possible values for drop down list in column A as either "NBA" or "MLB". If the value in cell A1 is NBA, I want cell B1 to have a drop down menu of all of the NBA teams. If the value for A1 is MLB, I want cell B1 to have a drop down menu of all of the MLB teams. How can I create it in Microsoft Excel? Also, if I add for example NFL as a third option in the list in Column A, could I make a third list for column B which would consist of the NFL Teams?
|
||||||||
|
Spreadsheet123. All rights reserved. Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. Spreadsheet123.com is not associated with Microsoft. |
|||||||||