what is the way to get dependent drop down list in Excel?(Ex: I have two drop down lists.One drop down contains Countries and second drop down contains states. So if i select "India" as country in first drop down then i want to see only that particular selected country states under second drop down).Please help me on this. Thanks in advance.

Asked by Last Modified  

3 Answers

Follow 0
Answer

Please enter your answer

Prabhas Kumar Panda

Advanced Excel & PowerPoint Trainer

Mr. Sharma, if you are aware of how to create a custom list then use indirect function on list formula box to create a dependency list.
Comments
Dislike Bookmark

Analyst - Excel, Macros, Access and SAS

Hi Sharma, Use Data Validation and Named Ranges to do this. In column A enter country names. In Column B enter state name of first country, Column C state names of second country and so on. Define range for the country name with the state list. Now using Data Validation, create drop down...
read more
Hi Sharma, Use Data Validation and Named Ranges to do this. In column A enter country names. In Column B enter state name of first country, Column C state names of second country and so on. Define range for the country name with the state list. Now using Data Validation, create drop down list in a column and in the next column use data validation and enter formula "=Indirect(Country Cell name)". Now dependent drop down list is created read less
Comments
Dislike Bookmark

Advanced Excel, VBA Automations, Reporting Insight

Easy way is, create two columns, one for countries and other for states. Let's say you have 3 countries. Go to Name Manager and type the name of first country followed by 1 after it (like India1) and select the range as the cells with that country's States. Repeat this for other two countries. Now coming...
read more
Easy way is, create two columns, one for countries and other for states. Let's say you have 3 countries. Go to Name Manager and type the name of first country followed by 1 after it (like India1) and select the range as the cells with that country's States. Repeat this for other two countries. Now coming to drop down, presuming this as simple cell validation, in first drop down, input the list as 3 countries. In second drop down, in list section put this formula,=if($A$="India",India1,if($A$="USA",USA1,"Others")) Now u select the cell validation in A1 as India and second drop down will show only States for India read less
Comments
Dislike Bookmark

View 1 more Answers

Related Questions

If we do course in VBA EXCEL, is these software is useful in USA? Because after completion of course I am flying to USA to pursue masters.
Yes definitely, Excel Vba is used everywhere despite of industry and geography...and it will definitely add value to your career and in your business also if u have...
Nanda
what is the recommended time needed to learn excel and cost ?
Excel is one of the tools that is most widely used by people all over the world, As others have said, it is a very vast topic, but the basics can be learnt in 10-15 hours. And there are many additions...
Hemant
It Can Be Possible To Be Prepare In a week Excel.
Yes.
Afshan
How to create pivot table in excel?
If you wan to analyze the only data that is on your sheet. First be sure all columns has header after than select any cell from your data and go to insert tab and click on pivot table.
Rahul
0 0
6
What is Microsoft Excel?
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Hardik

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Data Consolidation In Excel
Before you begin consolidating the data, make sure that there is consistency across the data sources. This means that the data is arranged as follows: Each range of data is on a separate worksheet. Each...

Itech Analytic Solutions

0 0
0
What is a SQL join?
A SQL join is a Structured Query Language (SQL) instruction to combine data from two sets of data (e.g. two tables). Before we dive into the details of a SQL join, let’s briefly discuss what SQL...

Itech Analytic Solutions

0 0
0
Variant Datatype: Excel/Access/Office VBA
The Variant data type is the data type for all variables that are not explicitly declared as some other type. The Variant data type has notype-declaration character. A Variant is a special data type that...

Punit Kumar

1 0
0
Advanced Excel - Excel What-If Analysis Goal Seek !

Amey Vidvans

0 0
0
Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!
In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma

1 0
0

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you