title: Return a list of values based on criteria - Excel
body: <p>I have a <code>PRODUCT</code> sheet with 500 products listed. In the same workbook, I have a <code>DOCKET</code> sheet - a copy of which is sent with each persons order. I'd like to be able to <code>"Enable"</code> any number of rows on the <code>PRODUCT</code> sheet, and have them appear on the <code>DOCKET</code>.</p>
  
  <p><a href="https://i.stack.imgur.com/k1o3J.png" rel="nofollow noreferrer">Product Sheet</a></p>
  
  <p>With the formula I'm currently using, I have to sort the <code>PRODUCT</code> list so that any of the lines I've <code>"Enabled"</code> are in the first few rows and it is tedious - <code>=IF(PRODUCTS!$A3="Enable",PRODUCTS!$C3,"")</code></p>
  
  <p>I'd like to be able to <code>"Enable"</code> a row anywhere in the <code>PRODUCT</code> list and have the value in <code>Column C</code> appear on the <code>DOCKET</code>.</p>
  
  <p>I think I need to slot 'INDEX' in there somewhere but can't for the life of me work it out. Anyone know what formula I should use?</p>