Forum Discussion
IF select option THEN receive new options
Hi
I have a table, and would like to add some selection items to it and I can't figure out how to.
I'll try to explain:
Per line item, the user need to 1st select a product version, and based on THAT first choice, 2nd having to select from a new list which is dependant on the first choise.
In the end I want both selected items to be displayed on the line.
Hope I explained myself good enough, and that somebody is able to help! 🙂
4 Replies
My answer workbook is consisted of 2 worksheets based upon my understanding of your query.
I hope one of them will be solution to your query.
Good luck.
Perhaps you mean dependant drop-down list as https://www.excel-easy.com/examples/dependent-drop-down-lists.html orhttps://www.youtube.com/watch?v=7mo4COng7Sg (lot of other samples)
Wauww SergeiBaklan - THAT looks very helpfull!! I'll start investigating rigth away!!! Thank you very much!!!!
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file.
So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
* Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
