Validating drop down
We can use this data to create a drop-down list that contains just the staff members for a selected team, and automatically updates when a different team name is selected.
Note that, in the above example spreadsheet, the formula "=$G" in cell E1 reflects team name that is entered in cell G2, and the formulas in cells E2 - E6 use the Hlookup and Row functions to look up the members of this team.
You can download the sample Drop Down Lists file here: Drop Down List Workbook.
We will now use the names in cells E2-E6 to create a drop down list that will automatically update every time the value of cell G2 is changed.I would like to have feedback from my blog readers.Please post your feedback, question, or comments about this article. NET is the superb platform for dump high-end applications, and there are a runs like the wind code of ways to what end programmers can use. This passage discusses seven lucky books that finance developers to raw material various features of . Video tutorials and step by step instructions are below In this tutorial, you'll see how to create a drop down list of choices in a cell, like the list of employee names shown below.To create a drop down list in Excel 2010, you can name a list of items, based on a named Excel table.