Jun 11 2021 05:27 AM
Hopefully someone can help be!
I cannot share the workbook, because it is company-sensitive.
But here's the issue:
I wanna create a dependent dropdown showing me these lists based on the three statements.
The three statements are combined in a cell with &""&.
I cant get it to work! Anyone have an idea of how to get this right?
Jun 11 2021 05:58 AM
You can assign names to L12:L14, M12:M14 etc. form L11, M11 etc., and use =INDIRECT(H9) as source for the data validation list. See the attached version.