Output in multi columns

[Sunilk]

I have one file will master data from which I need an option to select items in output sheet from drop down list.
I am able to do using Formula "Define Name" and "Validate Data" but this method gives me option only for two columns A & B.

The original data is big have deleted rows to reduce file size

Have attached xls file for reference

Thank you in advance

 

[Hui]

Have a read of:
http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset/

 

[Sunilk]

Hi Hui

Thank you for your reply will check if I am able to work as per the method shown.

Regards,

Sunil