I have a data sheet containing two columns (Core Indicators and Activities) with core indicators and their corresponding activities. Each Core indicator has about 4 or 5 unique activities. On a different sheet, I want to create drop-down data validation for Both the core indicator and the activity.
I created the one for Core indicators using the Drop-down (from a range) option in Data validation. For the Activity column, I want to be able to create a drop-down data validation of activities. The list in the drop-down should be based on the core indicator selected in the first column as each indicator has its corresponding activities.