title: How I do exclude 0 when using MIN with an IF?
body: <p>I have a workbook with 2 worksheets, <code>Sheet1</code> and <code>Sheet2</code>. </p>
  
  <p><code>Sheet1</code> has a value (product code) to look up, and an empty cell to fill:</p>
  
  <pre><code>A      B
  A100
  A200
  B150
  C3AB
  </code></pre>
  
  <p><code>Sheet2</code> has a bunch of product codes and costs:</p>
  
  <pre><code>A      B
  A100   35
  A100   14
  A100    0
  A200   10
  A200   12
  etc, etc, etc
  </code></pre>
  
  <p>I'm using the following formula in Sheet1 B1 to find the MIN matching value from Sheet2:</p>
  
  <pre><code>=MIN(IF(Sheet2!$A$1:$A$5=A1,Sheet2!$B$1:$B$5))
  </code></pre>
  
  <p>How can I also exclude returning a match of 0? In the case of product A100, I would want to return the lowest non-zero match which would be 14.</p>