displaying list based on data selection in drop down of data validation

[paradise]

hi,

Pls find enclosed in attachment a sample file.I have a list of data from A2:C18.The existing list is a sample only.In reality it is more than 2000.Here an user input data in E3.Now based on input data in E3, a selective list only from B column must be shown in F3 (and not all) by matching the data of E3 from A column.
Similary,in G3 column, selective list only must be shown based on selection of E3 and F3 so that an user can select.

the same would be for E4,E5 and so on.

if anyone require further info then kindly let me know.

Hope you did understand.

With Rgds,
Suresh

 

[Nebu]

Please go through the following link
http://chandoo.org/wp/2014/02/25/robust-dynamic-cascading-dropdowns-without-vba/
Thanks

 

[paradise]

Thanx for the reply.but I could not get into it. Can you do in my existing spreadsheet.