Multiple cascading dropdown lists in Google Sheets
Solved
Shinshu
Posted messages
6
Status
Member
-
123456azerty -
123456azerty -
Hello,
I'm trying to build a table with dropdown lists under certain conditions.
I have 7 product families, and within each family, a certain number of pieces of equipment.
In my table, there is a column with a dropdown list of these families.
In the adjacent column, I need to retrieve only the equipment from the selected family in the previous column.
I managed to do this for one line using the "Offset" formula, which generates a list based on my family in row 1. I then retrieve this dropdown list in my table.
However, I need to do this exercise for each row, which can create a very large number of lists, especially since I want to make a table for each month. This wouldn't be feasible.
Do you have a simpler solution?
Thank you.
I'm trying to build a table with dropdown lists under certain conditions.
I have 7 product families, and within each family, a certain number of pieces of equipment.
In my table, there is a column with a dropdown list of these families.
In the adjacent column, I need to retrieve only the equipment from the selected family in the previous column.
I managed to do this for one line using the "Offset" formula, which generates a list based on my family in row 1. I then retrieve this dropdown list in my table.
However, I need to do this exercise for each row, which can create a very large number of lists, especially since I want to make a table for each month. This wouldn't be feasible.
Do you have a simpler solution?
Thank you.
11 answers
-
I think I have found the formula that I had made and that inspired me this video
I only include images that I think will be quite explicit
1 the list sheet
2 the sheet of cascading drop-down lists incremented downward
