title: Varying validation drop-downs based on varying cell values
body: <p>I am attempting to have cells in Column “U” deliver different drop-down menus based on the corresponding value in column “D”. I have created 7 named lists:</p>
  
  <pre><code>List_117G
  List_152
  List_JMET
  List_XBAND
  List_PACWIND
  List_VORTEX
  List_ROVER
  </code></pre>
  
  <p>Those lists will be called up based on 7 values in column “D”:</p>
  
  <pre><code>G
  152
  J
  X
  D/E
  V
  R
  </code></pre>
  
  <p>So far I have only been able to get this to work for the first category <code>G</code>. When I change the value of column <code>D</code> from <code>G</code> to <code>152</code> I no longer get a drop-down. Here is the formula I am using in the List function of validation.</p>
  
  <pre><code>=IF(D6="G",List_117G,IF(D6="152",List_152,IF(D6="J",List_JMET,IF(D6="X",List_XBAND,IF(D6="D/E",List_PACWIND,IF(D6="V",List_VORTEX,IF(D6="R",List_ROVER,)))))))
  </code></pre>
  
  <p>What am I doing wrong?</p>