title: Returning All the Values based on the Exact Lookups
body: <p>I have a table that contains "Lookup" and "Result" columns. My goal is find a formula that can return all the values from the "Result" column which lookup contains a specific string, and store these values into a cell. Below is the example:</p>
  
  <p><a href="https://i.stack.imgur.com/tFrAs.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tFrAs.jpg" alt="enter image description here"></a> </p>
  
  <p>Is there a way to solve this?</p>
  
  <p>I have tried using <strong>Index Match</strong> and <strong>Vlookup</strong>, but both can only return the first matched value from the "Result" column.</p>