title: Copy cell contents if another cell has specific value
body: <p>I have a few rows of data that looks something like:</p>
  
  <pre><code>   A        B
  10501234   Cage
  10501235   Cage
  10501236   Cage
  10501237   Cage
  16001234   VIP
  16001235   VIP
  16001236   VIP
  </code></pre>
  
  <p>I need a formula in another row to separate out the VIP's. I want, for instance, E12 to check Row B for the word "VIP", if found, copy the corresponding number from A. Then I need E13 to check the list again and return the second VIP, E14 to return the third, and so on, if any exist. The information changes every day, sometimes there will be no VIP's, sometimes there will be dozens, but they will always be grouped similar to my example, all the VIP's together.</p>
  
  <p>Example Output:</p>
  
  <pre><code>   E
  16001234
  16001235
  16001236
  </code></pre>
  
  <p>Thank you for any advice you can offer.</p>