title: Use formula to copy cell values to another sheet if certain condition is satisfied
body: <p>I am trying to write a formula such that I can create a sub list in another sheet based on certain criteria. 
  I have two columns in sheet1 A &amp; B. I want to copy a value from cell B to the new list in sheet2 only if corresponding cell in A satisfies certain criteria. Please tell how to do it.</p>