title: Select a cell value from a range based on criteria
body: <p>I'm trying to figure out a sleeker method for determining the value of a cell based on criteria defined in a given range. To put it bluntly, I have a column for standard viscosity, standard temperature, and measured temperature. I'm needing to create a fourth column that will select the standard viscosity based on the measured temperature. For example, if measured temperature is greater than or equal to 0<sup>o</sup>C and less than 1<sup>o</sup>C: return standard viscosity for 0<sup>o</sup>C.  </p>
  
  <p>My issue is that I have a large range and find it to tedious to create a custom expression for each range. I've created a nightmarish function that was composed of IF(AND()) statements but find this exhausting, especially if I try to create an expression for a 0-200<sup>o</sup>C scale in single digit increments.  </p>
  
  <p>Here is a sample of a code that works but is quite cumbersome:</p>
  
  <pre><code>=IF(AND(G8&gt;=$C$7,G8&lt;$C$8),$D$7,0)+IF(AND(G8&gt;=$C$8,G8&lt;$C$9),$D$8,0)+....
  </code></pre>
  
  <p>or </p>
  
  <pre><code>=IF(AND(measured temp&gt;=0,measured temp&lt;1),$D$7,0)+IF(AND(measured temp&gt;=1,measured temp&lt;2),$D$8,0)
  </code></pre>
  
  <p>How could I approach this in a sleeker manner?</p>