title: List cell values if criteria met in Google Sheet
body: <p>I am working on a formula that will yield the following result:
   - Checks value of cells (B2:B) and returns the value of cells (A2:A) if the value is less than or equal to 'x'. </p>
  
  <p>See this image for reference. 
  <a href="https://i.stack.imgur.com/6njXH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6njXH.png" alt="enter image description here"></a></p>
  
  <p>The expected outcome here would be:
   - E2: Raking leaves, Shoveling Dirt
   - E3: Doing Laundry
   - E4: Changing Spark Plugs</p>
  
  <p>I can get the formula working on a basic level (per row) with this:</p>
  
  <pre><code>=IF(B2:B = 1,A2:A ,null)
  </code></pre>
  
  <p>I don't know how to go about comma-separating the titles in ONE cell like I've put in my example though. Can anyone help?</p>