title: complex excel table lookup returning value in row below
body: <p>I have a complex excel table lookup formula that I need help with. I have tried creating an index match match formula but this needs to look up on the same row, not using column headings in the match formula. Essentially need pull a number based on two parameters from the attached sample table. I'll just throw out an example to make the most sense. </p>
  
  <p>Example 1</p>
  
  <p>Parameter 1: B010, Parameter 2: 60.3 </p>
  
  <p>Based on the table I would need the formula to pull in 0.05</p>
  
  <p>B010 part is pretty simple. 60.3 is greater than 60 so it goes to the column with 60.6. And the formula needs to pull in the number BELOW the number that it finds in the row. Result = 0.05 <a href="https://i.stack.imgur.com/k9XIz.png" rel="nofollow noreferrer">image link</a></p>
  
  <p>Example 2</p>
  
  <p>Parameter 1: B010, Parameter 2: 45, result: 0.075</p>
  
  <p>Example 3 </p>
  
  <p>Parameter 1: B012, Parameter 2: 65, result: 0.033</p>
  
  <p>Is this even possible to do in excel?</p>
  
  <pre><code>B010 48.5 51.6 54.3 57.3 60 60.6 61.1 61.8 62.3 62.8 
       0.075 0.07 0.065 0.634 0.055 0.05 0.045 0.04 0.035 0.033 
  B012 48.5 51.6 54.3 57.3 60 60.6 61.1 61.8 62.3 62.8 
       0.075 0.07 0.065 0.06 0.055 0.05 0.045 0.04 0.035 0.033 
  B013 48.5 51.6 54.3 57.3 60 60.6 61.1 61.8 62.3 62.8 
       0.075 0.07 0.065 0.06 0.055 0.05 0.045 0.04 0.035 0.033 
  H010 48.5 51.6 54.3 57.3 60 61 62.1 63 64 64.9 
       0.065 0.06 0.055 0.05 0.045 0.042 0.04 0.038 0.035 0.033 
  H020 48.5 51.6 54.3 57.3 60 61.6 63.1 64.6 66.3 67.7 
       0.125 0.119 0.113 0.107 0.105 0.1 0.095 0.09 0.085 0.08
  </code></pre>