Forum Discussion
Yickod
Nov 22, 2023Copper Contributor
one dropdown to another
Hi all!
I am not a complete idiot when it comes to excel but far from the wizardry like you guys here.
So here goes;
I'm creating a template for ordering panels (cabinetry).
Panels have a color and a structure (the relief/type of skin).
What I would like to accomplish is when we select a manufacturer from a dropdown I automatically get another dropdown with the corresponding structures that manufacturer has.
Any wizards?...
https://www.dropbox.com/scl/fi/r9mqxx5x6pd85qimdm3zl/Orders-Template_231115.xlsm?rlkey=383x1kcxpuvh73pwtvfhreb1v&dl=0
2 Replies
- Riny_van_EekelenPlatinum Contributor
- YickodCopper ContributorHoly c#%p!
That is a simple formula!
I've been messing about with IF- and QUERY-functions for days now.
Thanks for the swift solution!
Wizard!