Real Estate Rent Roll

I'm trying to avoid manually each period to update my company's rent roll. I have highlighted starbucks as an example. The current rent is $3,200(G33) which is the old rent amount from 9/1/2012(M33). The rent should be $3,296(N34) since 9/1/2013(M34). I have added =Today() formula(A2). Can someone please guide me on a formula to input into (G33) that will automatically look at the current date (A2) and calculate date base off M33:M37 and choose the appropriate rental amount in cells N33:N37? Thanks excel forum! The worksheet is attached.

Solid work Chris S! I used to live in Lacombe, AB. I'm now in Arizona. I miss how green it is there.

Originally Posted by FDibbins

Nice work Chris

You need to absolute A2, so it doesnt change when you copy/paste elsewhere...
=IF($A$2<N34,O33,IF($A$2<N35,O34,IF($A$2<N36,O35,IF($A$2<N37,O36,IF($A$2>N37,O37,O33)))))

Also, JLG, you have circ ref errors in F191:G191 and F194:G194
F191=G191*12
G191=+F191/12

You need to resolve these, circ refs can cause errors in the most unexpected places

Thanks for the advice. Would Vlookup be a better option here?