title: How to use cell variables in filter function
body: <p>Being pretty new to google sheets I hope to find a way to use a cell as a variable without having to code custom functions for it.</p>
  
  <p>For example how do I use this function:</p>
  
  <p><a href="https://i.stack.imgur.com/awdFg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/awdFg.png" alt="enter image description here"></a></p>
  
  <p>so that I can declare a cell as a variable and use it in the function?</p>
  
  <p>Attempts:</p>
  
  <p><a href="https://i.stack.imgur.com/EVaQq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EVaQq.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/SBxrk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SBxrk.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/WMmqM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WMmqM.png" alt="enter image description here"></a></p>