Named Range Cannot Be found (even though it exists)

Hi, I am trying to build conditional dropdowns where a selection in the first column drives the values in the dropdown of the second. I have several columns of data and have given each a name I...