title: Match nth instance
body: <p>I have an array of data in a spreadsheet that I want to automagically pull the first seven instances that start with a specific string to seven independent cells so it can easily be seen what the full cell contents are. I have composed a formula that successfully finds the first occurrence but I can't find a way to extend this to the second, third etc. I have thought of using the previous cell's match as input to the next cell, but everything I've tried doesn't seem to work.</p>
  
  <p>I have found some examples that use VBA or CSE formulas, but any CSE formulas I have tried don't seem to work. But due to constraints imposed on me I can't use VBA or CSE anyway so I never looked too deeply in to it.</p>
  
  <p>Here is the formula that matches the first instance:</p>
  
  <pre><code>=INDEX($A$13:$A$5000,MATCH("start*",$A$13:$A$5000,0))  
  </code></pre>
  
  <p>This is in Cell A4; I would like A5:A11 to match the next six instances.</p>
  
  <p>Is this possible in a vanilla formula?</p>