Conditional multiple drop-down functionality

[prameetghosh87]

Background: We have database where we maintain brands and product details. There are around 20000 brands and around 30000 products. Please refer the image for sample data.

Question: We have now got some 100 brands. We need to check if they are present in the list of 20000 brands and display all similar brands in the drop-down list. For example, if user enter "ABC" brand, we should display brand starting with ABC in the drop down. In our case, it will be ABC, ABC Pro and ABC Plus. Now if the user selects "ABC Plus" under Brand field, we need to display corresponding product (ABC Plus 20 packets and ABC Plus 30 packet) in the drop down under Product field

Input​	Brand​	Product​
ABC	Drop-down will show brands with name starting with ABC. In our case it will be ABC, ABC Pro and ABC Plus	Drop- down will show corresponding product selected in Brand category.
DEF	Drop-down will show brands with name starting with DEF. In our case it will single entry - DEF.	Drop- down will show corresponding product selected in Brand category. In our case, it should be "DEF 10 packet".
XYZ	Drop-down will show brands with name starting with XYZ. In our case it will single entry - XYZ	Drop- down will show corresponding product selected in Brand category. In our case, it should show two values - "XYZ 20 packet" and "XYZ 40 packet".

Can anyone please help me with request.

 

[mamady]

This can be done in different ways, sharing a sample via XL2BB will make it easier to suggest the formula or functions.

Nonetheless, I would recommend following the below tutorial, you may be able to do it yourself

Best Regards