Julianohcosta
New Member
- Joined
- Apr 30, 2013
- Messages
- 12
I'm racking my brain to figure out a formula that, when I type an initial month and year, can find them in this table and return the cumulative index until today or an specified date. Exemple: The cumulative index from Oct/2011 to feb/2012. Then the formula would return 4,29%.
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Month/Year | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 |
2 | January | 0,00% | 2,58% | 1,73% | 2,67% | 2,18% | 1,46% | 1,27% | 1,53% | 1,97% | 1,27% | 1,38% | 1,43% | 1,08% | 0,93% | 1,05% | 0,66% | 0,86% | 0,89% | 0,60% |
3 | February | 3,63% | 2,35% | 1,67% | 2,13% | 2,38% | 1,45% | 1,02% | 1,25% | 1,83% | 1,08% | 1,22% | 1,15% | 0,87% | 0,80% | 0,86% | 0,59% | 0,84% | 0,75% | 0,49% |
4 | March | 2,60% | 2,22% | 1,64% | 2,20% | 3,33% | 1,45% | 1,26% | 1,37% | 1,78% | 1,38% | 1,53% | 1,42% | 1,05% | 0,84% | 0,97% | 0,76% | 0,92% | 0,82% | 0,55% |
5 | April | 4,26% | 2,07% | 1,66% | 1,71% | 2,35% | 1,30% | 1,19% | 1,48% | 1,87% | 1,18% | 1,41% | 1,08% | 0,94% | 0,90% | 0,84% | 0,67% | 0,84% | 0,71% | 0,61% |
6 | May | 4,25% | 2,01% | 1,58% | 1,63% | 2,02% | 1,49% | 1,34% | 1,41% | 1,97% | 1,23% | 1,50% | 1,28% | 1,03% | 0,88% | 0,77% | 0,75% | 0,99% | 0,74% | |
7 | June | 4,04% | 1,98% | 1,61% | 1,60% | 1,67% | 1,39% | 1,27% | 1,33% | 1,86% | 1,23% | 1,59% | 1,18% | 0,91% | 0,96% | 0,76% | 0,79% | 0,96% | 0,64% | |
8 | July | 4,02% | 1,93% | 1,60% | 1,70% | 1,66% | 1,31% | 1,50% | 1,54% | 2,08% | 1,29% | 1,51% | 1,17% | 0,97% | 1,07% | 0,79% | 0,86% | 0,97% | 0,68% | |
9 | August | 3,84% | 1,97% | 1,59% | 1,48% | 1,57% | 1,41% | 1,60% | 1,44% | 1,77% | 1,29% | 1,66% | 1,26% | 0,99% | 1,02% | 0,69% | 0,89% | 1,07% | 0,69% | |
10 | September | 3,32% | 1,90% | 1,59% | 2,49% | 1,49% | 1,22% | 1,32% | 1,38% | 1,68% | 1,25% | 1,50% | 1,06% | 0,80% | 1,10% | 0,69% | 0,85% | 0,94% | 0,54% | |
11 | October | 3,09% | 1,86% | 1,67% | 2,94% | 1,38% | 1,29% | 1,53% | 1,65% | 1,64% | 1,21% | 1,41% | 1,09% | 0,93% | 1,18% | 0,69% | 0,81% | 0,88% | 0,61% | |
12 | November | 2,88% | 1,80% | 3,04% | 2,63% | 1,39% | 1,22% | 1,39% | 1,54% | 1,34% | 1,25% | 1,38% | 1,02% | 0,84% | 1,02% | 0,66% | 0,81% | 0,86% | 0,55% | |
13 | December | 2,78% | 1,80% | 2,97% | 2,40% | 1,60% | 1,20% | 1,39% | 1,74% | 1,37% | 1,48% | 1,47% | 0,99% | 0,84% | 1,12% | 0,73% | 0,93% | 0,91% | 0,55% |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Plan1