title: It is possible to make 2 dropdownlist with different based on 1 value in a cell?
body: <p>After reading many tutorial, I managed to make a well effective dynamic dropdownlist</p>
  
  <p>My question is , let's say I want to add a third depend cell, and the problem the name of <strong>MyCell</strong> is already used once </p>
  
  <p>I'm using this line of code to bind the first dropdownlist  <code>(INDIRECT(SUBSTITUTE($U22," ","")&amp;"Col")),1)</code> </p>
  
  <p>Is it possible to add to this line of code something like  </p>
  
  <pre><code>(INDIRECT(SUBSTITUTE($U22+"Other"," ","")&amp;"Col")),1)`
  </code></pre>
  
  <p>as to bind the second dropdownlist   so I can name a cell :<strong>MyCellOther</strong> witch contains the other value I want to add </p>