dependendent Data validation

[yaparala]

Hi All,

I have data in sheet 1 "country,State,District'. in sheet one A1 column having dropdown and should be display as "country,state,district" and B1 column should be displayed relevant field data.
ex.
if A1 column select country then B1 displayed ind,us,uk.....
if A1 column select state then B1 displayed AP,MH,Ka.....
if A1 column select district then B1 displayed hyd,nellore...

 

[Luke M]

Check out this article:
http://www.contextures.com/xlDataVal02.html

 

[bobhc]

Good day yaparala

Have a good read of Luke Ms link for you cannot have it all in cell A1(or one column it would be a mess). Country in A column, State in B column and district in C column