So I have a cascading dropdown using data validation where I go from a Region_List to District_List. After selecting a Region, the "District" should contain selections only correlating to the selected Region. It looks like when I paste the "district_list2" formula into the excel sheet, I get the correct list of Districts per selected Region. However when I use the drop-down in the cell for the data validation, it's just showing my Defined Name "district_list2" in the cell instead of "Southeast; Texas; NYC". Please let me know if a screenshot would help!