title: How do you utilize a 'Data Validation' drop box as a 'Filter' condition?
body: <p>Slightly complex formating, but I hope someone can direct me in the right direction.</p>
  <p>Refer to this <a href="https://docs.google.com/spreadsheets/d/1swEFO_2Y3uglQ0TzQpzBBMnJ5eC63I6h2Bu_B3M9J0g/edit?usp=sharing" rel="nofollow noreferrer">Demo Sheet</a> before reading as I'll be referring to it throughout this post.</p>
  <p><strong>What I'm Trying to Accomplish:</strong> I'm trying to 'Filter' the &quot;Ongoing Sales&quot; sheet based on which store is selected (<code>G13</code>). I have a formula that will automatically populate the rows in each branded section and would like to add another condition to that formula stating the following:</p>
  <ul>
  <li>If <code>'G13'</code> is found in <code>'Current Markdown Sheet'!$P$16:AC16</code>, display/filter the corresponding column if the value's in said column are greater than 0.</li>
  </ul>
  <p>My current code (Which is filtering 'SKU's based off of brand names and if its men's, women's, or kids):</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>=FILTER('Current Markdown Sheet'!$B$16:$B, REGEXMATCH('Current Markdown Sheet'!$A$16:A, "ASICS"), REGEXMATCH(LEFT('Current Markdown Sheet'!$C$16:C,2), " M"))</code></pre>
  </div>
  </div>
  </p>
  <p>Here are some visuals if my explanation wasn't good enough :</p>
  <p><a href="https://i.stack.imgur.com/zaUQ8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zaUQ8.png" alt="" /></a>
  ^ Where I want the condition to go. (You can replace the <code>&amp;T(N(&quot;INSERT FILTER CONDITION HERE&quot;))</code>) ^</p>
  <p><a href="https://i.stack.imgur.com/Lwe28.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Lwe28.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/WI924.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WI924.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/Qgpmn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Qgpmn.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/xFrRD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xFrRD.png" alt="enter image description here" /></a></p>
  <p><strong>Some Rules to Follow:</strong></p>
  <ul>
  <li>You cannot alter the &quot;Current Markdown Sheet&quot; in anyway (Add data, remove data, etc).</li>
  <li>I dont necessarily need it to show &quot;All Stores&quot;, but if it's possible; Bonus points .</li>
  </ul>
  <p>Best of luck everyone, and I thank you in advance!
  Cheers!</p>