I'm trying to develop a table where when you select one Insulation Type from a dropdown menu, you are shown the possible options for start and end values for that insulation type. I know that you can do cascading dropdowns where one references, the other, which references another. But I need both the start and end options to populate based on the same reference - Insulation Type that's selected. I've thought about doing a workaround where the End dropdowns could reference the Start choices, but there are repeats in the Start Values so that's not possible.
I highlighted in yellow the cells where I would like to see dropdowns that indicate the possible end value options based on the Insulation Type. Any help is appreciated.
Bookmarks