Forum Discussion
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 'DROPDOWN LIST' (Cell B4) it should populate Worksheet Product Selector (Cell K4) with (Cell G2) C300 - Crimp 300mm2 copper cable from Worksheet 'DROPDOWN LIST'
Please can you help me with creating the right formulae?
I tried IF and VLookup.
Any advice welcome, thank you.
Toby
6 Replies
Badgesr456 Why not upload the file you are working on. Screenshots aren't really useful.
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.
