title: Getting VLOOKUP() to default to closest date
body: <p>I have two tables shown in the link <a href="http://imgur.com/a/4nqY1" rel="nofollow">here</a>.  I am trying to calculate columns <code>J</code> and <code>K</code> in the second table based on the row that has the closest date match in the first table.  To give you a better idea of what I'm trying to do, I have this formula for column <code>J</code>:</p>
  
  <p><code>=F3-VLOOKUP(C3,'Agency Comps2'!B:G, 5, TRUE)</code></p>
  
  <p>And this formula for column <code>K</code>:</p>
  
  <p><code>=H3-VLOOKUP(C3,'Agency Comps2'!B:G,5,TRUE)</code></p>
  
  <p>Where <code>Agency Comps2</code> is the name of the first sheet that I'm trying to look up values in.</p>
  
  <p>As you can see, the values I'm getting are either wrong, or <code>#N/A</code>.  I have been trying to find a way to make <code>VLOOKUP()</code> default to the closest date, but I can't seem to do so.  Can anyone help me get the values I'm looking for?</p>