I'm having difficulty in creating a drop down menu thats dependant on the 1st drop down.
For example, I have a list of product lines, Regulatory Compliance, Anti-Fraud, Financial Custom, Financial Control.
I have a separate list of the items that relate to Regulatory Compliance, Anti-Fraud, Financial Custom, Financial Control.
For the product lines, I created a named range called product lines.
For the separate lists, I created a named range and named them Regulatory_Compliance and Anti_Fraud, Financial Custom and Financial Control.
After the drop down for Regulatory Compliance was selected. The other cell, I entered in the data validation prompt INDIRECT(SUBSTITUTE(B2," ","") and this does not give me the list of options from my separate list that relate to the Regulatory Compliance.
I know that the =indirect(b2) would work for example if the list was only 1 word cells.
Please can you advise what steps I need to do to help get the necessary results.
For example, I have a list of product lines, Regulatory Compliance, Anti-Fraud, Financial Custom, Financial Control.
I have a separate list of the items that relate to Regulatory Compliance, Anti-Fraud, Financial Custom, Financial Control.
For the product lines, I created a named range called product lines.
For the separate lists, I created a named range and named them Regulatory_Compliance and Anti_Fraud, Financial Custom and Financial Control.
After the drop down for Regulatory Compliance was selected. The other cell, I entered in the data validation prompt INDIRECT(SUBSTITUTE(B2," ","") and this does not give me the list of options from my separate list that relate to the Regulatory Compliance.
I know that the =indirect(b2) would work for example if the list was only 1 word cells.
Please can you advise what steps I need to do to help get the necessary results.
