Forum Discussion
Badgesr456
Oct 07, 2021Copper Contributor
Creating a Product Selector
Hello I am trying to create a Product Selector based on information selected from drop down menus. I am trying to achieve: Worksheet Product Selector: When the user selects '300mm2' from ~Worksheet...
Riny_van_Eekelen
Oct 07, 2021Platinum Contributor
Badgesr456 Why not upload the file you are working on. Screenshots aren't really useful.
- Badgesr456Oct 07, 2021Copper Contributor
- Riny_van_EekelenOct 07, 2021Platinum Contributor
Badgesr456 Thanks! You might need to re-think your design, as you probably want to work with dependent dropdown lists. But, if that's not the case, perhaps the formula (L8 in the Dropdown sheet) in the attached file will do for you. It's not really straightforward, but it work is this specific case.
- Badgesr456Oct 07, 2021Copper Contributor
Hello Riny, Sorry to trouble you again
The seems to be an issue with the result
50mm should be C50 not C150
Please see attached
Can you help, thanks