title: Returning Multiple Results with Match Function
body: <p>I am looking for matches of information in Column E of one worksheet to Column E of a second worksheet.</p>
  
  <p>I've used:
      =MATCH("<em>"&amp;E1&amp;"</em>",'SHEET1'!E:E,0)</p>
  
  <p>and this returns me which row the match is in.</p>
  
  <p>However I have multiple hits on my search, but it is only returning me the row of the first hit.</p>
  
  <p>Is there a way to get a list of all hits, not just the first occurrence?
  Thank you!</p>