title: Index & Match formula does not show the repeated entry with different value
body: <p>I have an <a href="http://s000.tinyupload.com/index.php?file_id=53364233111112661814" rel="nofollow noreferrer">excel spreadsheet - downloadable here</a> contains some columns as following :</p>
  
  <pre><code>Column A : Companies' Names
  Column B : Project's Name 
  </code></pre>
  
  <p>When I try to filter my data using combo box to show only companies in specific area and use <code>INDEX</code> and <code>MATCH</code> to show all the related data in same row with the company name in the search result, since I have some companies has more than project, unlikely <code>INDEX</code> and <code>MATCH</code> just repeat first row for the company name only like the following:</p>
  
  <pre><code>Company1    Project 1
  Company1    Project 1
  </code></pre>
  
  <p>Although company 1 has two projects 1 and 2 and must be as following</p>
  
  <pre><code>Company1   Project1
  Company1   Project2
  </code></pre>
  
  <p>But the formula just keep repeating first row it finds.</p>
  
  <p>Pic 1 - the search result which is incorrect</p>
  
  <p><img src="https://i.stack.imgur.com/6i927.png" alt="enter image description here"></p>
  
  <p>Pic 2 - the main data which I want to appear like this in the search result</p>
  
  <p><img src="https://i.stack.imgur.com/a6ijU.png" alt="enter image description here"></p>