fareedexcel
Member
Hello,
I need to have a dependent drop down based on a list of values. Using the dynamic array formula, the required result is obtained. However, when I tried to use the same formula in the data validation list, the following error appeared.
"The source currently evaluates an error."
The following formula is used to create the drop-down result values:
I have attached the sheet for your reference. Kindly help to solve the data validation list issue. I'm not sure what needs to be done in the Name Manager to avoid the error.
I need to have a dependent drop down based on a list of values. Using the dynamic array formula, the required result is obtained. However, when I tried to use the same formula in the data validation list, the following error appeared.
"The source currently evaluates an error."
The following formula is used to create the drop-down result values:
Code:
=IF(Q7=$V$6,FILTER($V$7:$V$13,$U$7:$U$13=$P7),FILTER($W$7:$W$13,($W$7:$W$13<>"")*($U$7:$U$13=$P7)))
I have attached the sheet for your reference. Kindly help to solve the data validation list issue. I'm not sure what needs to be done in the Name Manager to avoid the error.