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

How to use vlookup in excel?
Syntax for using vlookup function is =VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUMBER)
Ankita
0 0
7

Is learning Tally good or is learning Advanced Excel and Python good? Which one will be better for getting a job? What would be the general cost of learning Tally, Advanced Excel and Python? Which are the best tutors or institutes near to Kudlu Gate and Electronic City?

 

 
As a beginner, you should go with Advance Excel and MIS reporting. After that, you can go for VBA, SQL, and Python in the end. Follow this career path. You will end up being a data analyst and package raging from 8-12lakh pa.
Prabhu

Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System.

 

Suppose our Customer requires following:

An Excel Software for POS, with following functionalities:

  1. It should have an "Open List" for capturing product related information.
  2. It should have automatic bill numbering
  3. It should have Printable bill
  4. It should have a customer database form and recording
  5. It should take not more than 30 minutes of training to learn and operate

Can you make that?

How much time will it take to you to make it completely?
Maybe yes! I'll require a bit more information to deep dive in it.
Bikram Jeet
0 0
9
How can I create an organization chart in MS Excel?
Best option would be smart art tools for creating an organisational chart.
Poojashree
0 0
5
Excel formulas in advance level?
In excel we have lot of staff and formulas, we can learn based on your requirement, in excel vlookup, hlookup, pivot table if condition, sumif ifs, countA, if ifs, data validation, etc. and we have to...
ManojGS

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

Ask a Question

Related Lessons

Ever been stuck calculating GST manually?

Mahesh

0 0
0
Generate Employee Payslip using Excel & VBA Macros
yes we can generate the Payslips for each employee from a huge data in the excel. We can generate a separate Excel sheet for each employee and also can create Payslip Excel files with the names of the...

Venkata Seshasai Kanuru

1 0
1
Excel Tip 1: VLOOKUP to pull left column values
Hi,Most of us know that using Vlookup function we can get the right column values, however by using Choose function in Vlookup table array, we can pull left column values as well. In the below screenshot...

Karthik Dale

0 0
0
VBA Function -
Using FORMAT Function in VBA we can modify the format of Numbers, Dates, Times & String. Syntax: FORMAT(expression, format, , ) 1. Formatting "Numbers" using FORMAT function in VBA SUB Format_Numbers() MsgBox...

Naga Satyanarayana anantapalli

0 0
0
Some Excel Functions
You need to know about these following functions which are based on Microsoft Excel 2010.1. Speedily Move and Copy Data in Cells:-If you want to move one column of data in a spreadsheet, the fast way...
I

ICreative Solution

0 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