help on dynamic dropdown list

[Jayadev Sarangi]

Hello,


I need help on dynamic drop down. Below is the requirement.


Cel A1, A2 and A3 contain 1,1 and 2 respectively. Cell B1, B2 and B3 contain A, B and C respectively. I want to have a drop down where I select 1 or 2 then in the next cell it will automatically show up the respective valude from column B. For example - if I select 1 from the drop down, in the next drop down it should only show A and B.


Kindly advise and thanks a lot for the help always.


Regards

Jay

 

[SirJB7]

Hi, Jayadev Sarangi!

Give a look at this topic:

http://chandoo.org/forums/topic/data-validation-list-automatically-shows-the-first-item-in-the-list

Regards!