title: Google Sheets match/intersect of two sets
body: <p>I have keywords in one sheet:</p>
  
  <p><a href="https://i.stack.imgur.com/iJGTw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iJGTw.png" alt="enter image description here"></a></p>
  
  <p>And results in another sheet:</p>
  
  <p><a href="https://i.stack.imgur.com/v0cvd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/v0cvd.png" alt="enter image description here"></a></p>
  
  <p>I want to find if any of the words in <code>search</code> exist in <code>keywords</code>. And if there is a word that is in both, the <code>results</code> will show any <code>result</code> that has the keywords.</p>
  
  <pre><code>=join(", ",filter(A3:A5,match(split(B3:B5,", "),split(F3,", "))))
  </code></pre>
  
  <p>In this case, I get an error <strong>#VALUE!</strong> where it should say <code>Result 1, Result 2</code></p>
  
  <p>The error says </p>
  
  <blockquote>
    <p>FILTER range must be a single row or a single column.</p>
  </blockquote>