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

Learn Microsoft Excel Training

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

Is MS Excel very easy to learn?
Yes it is easy application to learn
Kamal
0 0
6
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin
What are some cool Microsoft Excel tricks?
there are 1000 of tricks that can be done in excel from basic to complex. but most awesome trick is to play old dosky games in excel, remember the child hood games like mario, boomerman , contra...
Shagufta
0 0
8
What is the one formula that you can never use in an excel?
First we need to differentiate between FORMULA and FUNCTION before answering the question. Formula is anything that starts with "=" sign. Like =3+9. However, function is a subset of formulas, and they...
Raja
can i teach
For teaching two things are must 1) you must have sound knowledge of the topic 2) then you must know the art of teaching. You should teach in a such a way that you are able to make people understand...
Abdul

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

Ask a Question

Related Lessons

VBA - Loop Demo

Vipin K

0 0
0
Hide Duplicate Values & Apply Borders Using Conditional Formatting
Please refer following screenshots:1st Screenshot: Original Dataset2nd Screenshot: After Conditioinal Formatting is applied In 2nd screenshot, using Conditional Formatting:1) Repeat months are...

Ankur Sharma

1 0
0
Benefits Of E-Learning
From an organizational point of view, e-learning courses can be conducted by trainers in one location and it can benefit employees across continents in different time zones. This can bring down training...
E

Edusmart Skills

0 0
0
MS Excel: Formulas and Functions: Listed by Category
MS Excel: Formulas and Functions: Listed by Category Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel....

Siddhartha Mahapatra

0 0
0
VBA Tip: Repeating Emp Names N number of times using 4 different loops
Hi All,This is a requirement from one of our student and here we are posting the question along with solution (this can be achieved using 4 different loops). In Column “J” there are few employee...

Naga Satyanarayana Anantapalli

2 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