Dear Aditya

The below link on dependent list will definitely help

http://contextures.com/xlDataVal02.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