title: Dynamic Named Range based on second column's value without VBA
body: <p>I'm trying to build an interface that allows a user to select a category of modification (17 total categories) and have the second drop down box list only those modifications (anywhere from 5-30 modifications) that apply to that category. </p>
  
  <p>Normally, I would set up reference tables to indicate which modifications apply to which category. However, this particular tool is going to have new data populated every week by a non-technical person. There is already a structure in place that will assign each modification number to a given category. However, the list of modification numbers present in any given data pull will change so much that maintaining the separate lists will get overly cumbersome.</p>
  
  <p>My hope is that there is a way to have a dynamic named range contain only those values where the category column is equal to the selected category. </p>
  
  <p>I want to use DNRs because I will be using it as part of a validated data list that will end up controlling the display of a handful of graphs for the end user. Additionally, we aren't allowed to use macros for our shared spreadsheets. </p>
  
  <ul>
  <li><code>A1</code> would contain the category (I can get this named range to work just fine, it's a basic one)</li>
  <li><code>A2</code> should contain only those mods from column C where the corresponding cell in column D equals the value of <code>A1</code>.</li>
  </ul>