Differing drop down choices

[osaben]

I have done some research and I have not been able to track down any information on the following. Can anyone offer any advise/direction?

I want to provide a cell with drop down options that are base on the information entered in another cell.

Is this possible in excel 2016 ?

Thanks in advance!

 

[DanteAmor]

Something like this

https://www.youtube.com/watch?v=5nb84p2wX-c

 

[Yongle]

Yes - this is achieved using dependent dropdowns
See this link https://www.contextures.com/xlDataVal02.html

 

[osaben]

Thanks! I will review the links you have sent!

thanks again!

 

[DanteAmor]

Thanks! I will review the links you have sent!

thanks again!

I'm glad to help you. Thanks for the feedback.