title: List all matched instances of a value
body: <p>I am trying to build an order guide and want everything I order from one vendor put onto a separate sheet. </p>
  
  <p>Sometimes I bring on new products from vendors and need the list to automatically update as well. </p>
  
  <p>Currently my formula looks like this:</p>
  
  <pre><code>=IF(ISERROR(INDEX('Order Guide'!A1:B240,SMALL(IF('Order Guide'!B1:B240=$A$1,ROW('Order Guide'!B1:B240)),ROW('Order Guide'!1:1)),2)),"",INDEX('Order Guide'!B1:B240,SMALL(IF('Order Guide'!B1:B240=$A$1,ROW('Order Guide'!B1:B240)),ROW('Order Guide'!1:1)),2))
  </code></pre>
  
  <p>But it isn't working. Where am I messing up?</p>
  
  <p>Listed here is my current spreadsheet: 
  <a href="https://i.stack.imgur.com/RKIQd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RKIQd.png" alt="Photo of current spread sheet"></a></p>
  
  <p>Basically, I want everything in <code>Column B</code> that says <strong>National</strong> to go to a separate sheet.</p>