Forum Discussion

Badgesr456's avatar
Badgesr456
Copper Contributor
Oct 07, 2021

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...
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 07, 2021

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.

Resources