In order to compute and forecast an estimate of the triennial rent adjustment, i need to compute the rise in the cpi (table) from the lease date (cell c3) and the present date (cell a2) or the closest publishe date existing in the table. The % rise is easy to calculate present index / opening index -1 = % rise in cpi. I update the index monthly when onthe bls publish it.
Last edited by mcarr5; 06-10-2009 at 01:41 PM.
To pick the value out of the table as it applies to cell C3:
=INDEX(J5:V70, MATCH(YEAR(C3), I5:I70, 0), MATCH(MONTH(C3), J4:U4, 0))
To pick the value out of the table as it applies to cell A2:
=INDEX(J5:V70, MATCH(YEAR(A2), I5:I70, 0), MATCH(MONTH(A2), J4:U4, 0))
Now do what you will with those two values...but note that the table does not currently have a value for A2, so...
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thank you so much. I'll now do the calculations.
I'd like to subscribe or list you as 'friend'. May I? I'm relatively new to the forum.
Mike
The friends thing is fine, of course, though not much is done with it as I can see on the forum so far. Any questions/needs you may have are best served by simply posting a new message.
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks