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.

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Oct 07, 2021

      Badgesr456 Aha! that's because "50mm2" is first found in "150mm2". To overcome, you could add a space before the item from the dropdown list. Thus " 50mm2". See attached.

       

      BUT, this is not very professional, and I believe you need to redesign your schedule. If you have a dropdown list to begin with, and each item relates to only one other item, why not work with one of Excel's lookup functions. Which version are you working with. But perhaps I'm misunderstanding your intentions altogether.

       

Resources