How do I have hierarchial drop down lists in Excel

K

Kunal

Hi all,
I want to create a heirarchial drop down lists in excel.How do I do it.
For Ex-
Column A has the following drop down elements- Animals,Birds,Continents
Column B should have the following drop down elements depending upon the
selection in column A-
if (A=Animals) B=(Tiger,Lion,Elephant)
if (A= Birds) B=(Crow,Sparrow,Eagle)
if(A=Continents) B = (Australia,Europe,Antartica)
Thanks in advance,
Kunal.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
dependent, multiple variable, drop down list 2
dependent drop down list 1
Data Validation and drop-down list using IF, AND and what else? 8
SUM determined by drop-down list 9
Drop Down Lists 2007 10
How do I create a drop down box within a drop down box? 1
drop down list 2

Top