I want to extend this question:
I have a table with Vlookup, which is used to create a Dropdown list depended on another selection of a first dropdown list.
Now if I Change the selection on the first Dropdown list, the table gets changed and the second Dropdown list is altered. However,only the entries/items in the second Dropdown list Change, but not the already choosen entries/items of this list in one cell (e.g. Keeper: ("B2")). How can I update also already choosen items?
Thanks for your hints!
Team | BVB | SVW | Table for Dropdown 1 | Table for Dropdown 2
Keeper | Mister 1 | Mister 11 | BVB | =VLookup...
Libero | Mister 2 | Mister 22 | SVW | =Vlookup...
Libero2 | Mister 3 | Mister 33 | =Vlookup...
ColA Col B
Row1 Team: Choose Dropdown 1 with team
Row2 Keeper: Selected Dropdown 2 with player
Row3 Libero: Selected Dropdown 2 with player
To post as a guest, your comment is unpublished.· 10 months agoSorry, I have no idea about this problem. maybe someone can help you if you carry on the problem in our forum https://www.extendoffice.com/forum.html