Aditya, you can also refer the below which explains about dependent dropdowns
from * a * sorted list...

http://contextures.com/xlDataVal13.html

If this post helps click Yes
---------------
Jacob Skaria


"aditya" wrote:

i want to make conditional dropdown like this

if a1="x" dropdown in a2 should be US,CANADA,MEXICO
if a1="y" dropdown in a2 should be CHINA,JAPAN,INDIA,KOREA


thank you in advance