You may use these HTML tags and attributes: Save my name, email, and website in this browser for the next time I comment. Your email address will not be published. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself. References are immediately evaluated to display their contents. Use of Indirect Function : Returns the reference specified by a text string. So in B2 Cell now you will see the drop down list for country austrelia or the value which is available in A2 Select Cell B2 -> Click on Date Menu -> Data Validation -> Select Settings -> From Allow Drop-down select value as List -> in Source Text box provide value as “=indirect(A2)” and Click on Ok Button. Step 5) Now Create the Dependent Drop down list. Step 4) Now In Create the First Country drop ListĬlick on Data Menu -> Data Validation -> Select Settings -> From Allow Drop-down select value as List -> in Source Text box provide value as “=country” and Click on Ok Button. Step 3) Create the Named list of Austrelia and Germany as mentioned below. Step 2) Now Create the NamedList for City belong to India as mentioned below. To Create the named list select the values, here Select from cell value from A2 to A4 and then click on the Name Box left of the Formula Bar.Provide name as “Country” and press Enter. Step 1) Create the Country list then select those country and create the named list. In this article will see based on selection of country drop down related city drop down should get populated. To populate the list based on selection,microsoft excel is providing feature of dependent drop down list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |