title: Excel MATCH with match_type = -1 failing
body: <p>I'm struggling with the <code>MATCH()</code> function in Excel when using a match_type of <code>-1</code> (greater than).</p>
  
  <p>I have a table as follows:</p>
  
  <pre><code>      -A-     -B-
  -1-   83      0
  -2-   83      1950
  -3-   88      2440
  -4-   93      2440
  -5-   93      0
  -6-
  -7-   85.6
  </code></pre>
  
  <p>I want to find the gradient at any point on the envelope that these points create, so I want to find the corresponding column -B- value for an intermediate column -A- value.</p>
  
  <p>Step 1 in my process is to find the values <em>below</em> my query value. I do this with:</p>
  
  <p><code>=MATCH(A7,A1:A5,1)</code> (A7 contains my lookup value)</p>
  
  <p>This works fine, and I then use the result of the <code>MATCH()</code> function with <code>INDEX()</code> to lookup the corresponding -B- column value.</p>
  
  <p>Step 2 in my process is to find the values <em>above</em> my query value. For this I have:</p>
  
  <p><code>=MATCH(A7,A1:A5,-1)</code> (A7 contains my lookup value)</p>
  
  <p>However this does not work. I get an <code>=N/A</code> error in the formula cell.</p>
  
  <p>Showing calculation steps doesn't help as all of the values and ranges are being picked up correctly from what I can see....</p>