title: Can I use Offset and Match to find the MIN value in a range of results?
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.00
  A100   14.00
  A100   50.00
  A200   10.00
  A200   12.00
  etc, etc, etc
  </code></pre>
  
  <p>I'm using the following to find a match between worksheets and populate <code>column B</code> in <code>Sheet1</code>:</p>
  
  <pre><code>=IFERROR(OFFSET(Sheet2!$B$1,MATCH(A1,Sheet2!$A:$A,0)-1,0), "")
  </code></pre>
  
  <p>Can I throw a <code>MIN</code> in there somewhere to pull out the lowest value in <code>column B</code> of <code>Sheet2</code>?</p>