title: Formula to determine whether a value is within a range
body: <p>My company is eligible to receive additional money if I receive a product within a certain time period. As long as F2 (Date Rec'd) falls on or between A2 and B2 (The Eligible Dates), and G2 (my model) matches C2 (eligible model), I am eligible to receive a certain $$ amount (D2). I would like that to show up in H2.</p>
  
  <p>What I received...<br>
  In F2-F900, I have a date in which a product was received.<br>
  In G2-G900, I have the specific model # that was received.</p>
  
  <p>What the program allows...<br>
  In A2-A250, I have a start date<br>
  In B2-B250, I have a end date<br>
  In C2-C250, I have a model #<br>
  In D2-D250, I have a $$ amount that I am eligible for</p>
  
  <p>If I wasn't worrying about the dates, I would use Vlookup.</p>
  
  <pre><code>=VLOOKUP(G2,$C$2:$D$950,2,FALSE)
  </code></pre>
  
  <p>...however, I don't know what to enter to make it meet more criteria.</p>