title: VLOOKUP for last day of month
body: <p>I have an Excel spreadsheet to track expenses using =VLOOKUP.</p>
  <p>In column C, I have the day of the month running down (starting with January), <code>1,2,...,31,1,2...,28,1,2,...31....</code>.
  In column G, an amount (expense) is displayed based on column C from a lookup table.  My lookup table has 2 columns, R for day, and T for expense.</p>
  <p><strong>The Vlookup is:</strong></p>
  <pre><code>=VLOOKUP($C2,$R$3:$T$30,3,FALSE)
  </code></pre>
  <p>My issue is that one of the days I want to use is not a specific day, like <code>1,2 or 30</code> but the last day of the month.  I do have a separate column with the full month to reference if need be.  Is there any way to incorporate this?  I have seen =EOMONTH, but am not sure if this then needs to be separate from the VLOOKUP table?</p>
  <p><em>Edit not by OP</em></p>
  <p><img src="https://i.stack.imgur.com/pAFuT.gif" alt="SO19697681 question example" /></p>
  <p>The image shows an example for November, which in itself is a bad example since I have the lookup table set for the date of 30, so it works as expected (a workaround at the time), but if the month has 28, 29, or 31 days, the &quot;deposit&quot; does not come on the correct day [sorry, in my original post I put &quot;expense&quot;, which is incorrect; but all references are correct].</p>
  <p>In reality, what I did was just use <code>EOM</code> as my lookup value, and <code>EOM</code> in the day field, so I didn't need to change any formulas.</p>