title: What method can filter two pairs of data using filter() or other recommanded way?
body: <p><a href="https://i.stack.imgur.com/cF89A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cF89A.png" alt="enter image description here" /></a></p>
  <p>I want to use filter() to search from <code>B2:B</code> corresponding to
  the range like <code>F2:F3</code></p>
  <p>I use <code>=filter(A2:A,B2:B = F2:F3)</code>,but there is just one data <code>Jack</code></p>
  <p>I know this example can using FILTER to do the same thing like this.
  <a href="https://i.stack.imgur.com/8cv4A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8cv4A.png" alt="enter image description here" /></a></p>
  <p>But now if there is a lot of data, it may not meet my needs.</p>
  <p>Then I use <code>=ArrayFormula(filter(A2:A,B2:B = F2:F3))</code></p>
  <p>And it's not useful, too. (I don't know how to use <code>arrayformula()</code> methods)</p>
  <p>What should I fix the formula and parameters?</p>