title: If Cell B1 is "x", pull Cell A1, otherwise ignore
body: <p>Essentially, I'm trying to come up with a formula that only extracts data from rows where a condition in a separate column of the same row is met, the condition is a constant and I know the answer must be stupidly easy, but I can't figure it out. </p>
  
  <p>Example, say you have array like so:</p>
  
  <pre><code>Name    Surname  Status
  ------  -------  ------
  John    Bon      Green
  Jane    Dane     Red
  Alex    Flex     Yellow
  Romeo   Cameo    Green
  Boris   Horis    Green
  Julius  Dubious  Yellow
  Holy    Macaroni Green
  </code></pre>
  
  <p>And you wanted to have a list of people on a separate worksheet only with people with green status, without any blank rows in between when you drag it. </p>