title: Index/Match to Return Multiple Values
body: <p>I've successfuly used INDEX and MATCH, but I have a problem.</p>
  
  <p>For example, if the data were:</p>
  
  <pre><code>green apple | walmart |  5 
  green apple | walmart | 23
  red apple   | walmart |  5
  orange      | macy's  |  4
  </code></pre>
  
  <p>I would want to get all <code>green apple</code>s sold in <code>walmart</code>, and get the amount of each, for example: 5, 23 ,5.</p>
  
  <p>When using INDEX MATCH, I can only get the first one it matches to. How can I to get multiple values and concatenate them in a single cell?</p>
  
  <p><em>Edit</em> Further example (not added by OP) from comment:  </p>
  
  <p><img src="https://i.stack.imgur.com/YDlCV.gif" alt="SO17620123 question example"></p>