title: Look if number fails between range in column A & B then multiply original number by number in column D of same row
body: <p>Here is my challenge.  I need to enter a value on <code>C16</code> and then identify what range of numbers this number falls into between column <strong>A</strong> &amp; <strong>B</strong>. I have gotten part of the way with the following command: <code>=VLOOKUP(C16,$A:$B,TRUE)</code> however it always outputs the value of the correct line that is in column <strong>A</strong>.<br>
  What I really want to do is enter value in <code>C16</code>, identify which line that value falls into then multiply the value in <code>C16</code> against the number in Column D of the same line that value was found on and output that answer.<br>
  Below is a sample of column A - D &amp; Rows 2-5.  Lets say I enter the value of 10 in <code>C16</code> it should identify that falls into the range that on Row 1 then multiply the value in <code>C16</code> which is 10 in this case by <code>D1</code> resulting in an output of $1690.00</p>
  
  <pre><code>1       99      1    $169.00 
  100     499     1    $127.00 
  500     1,999   1    $78.00 
  2,000   4,999   1    $58.00 
  </code></pre>
  
  <p>Any and all help much appreciated!</p>