Forum Discussion
applying Drop down list on cells based on condition
First, select the range G4:J7.
On the Formulas tab of the ribbon, click Create from Selection.
Make sure that only the check box Top Row is ticked, then click OK.
This creates named ranges First_First, First_Second etc. (Slashes / aren't allowed in a name, so they are replaced with underscores _).
Then select B6:B9. Create data validation of type List with source =INDIRECT($C6&"_"&$D6)
See the attached version.
First, select the range G4:J7.
On the Formulas tab of the ribbon, click Create from Selection.
Make sure that only the check box Top Row is ticked, then click OK.
This creates named ranges First_First, First_Second etc. (Slashes / aren't allowed in a name, so they are replaced with underscores _).
Then select B6:B9. Create data validation of type List with source =INDIRECT($C6&"_"&$D6)
See the attached version.