actuary0123
New Member
- Joined
- Feb 2, 2014
- Messages
- 38
I have a few tabled on a worksheet that organize interest rates in the following order:
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
What Would I Like to Do:
On a separate sheet, I want to choose the country name, year and month and pull the corresponding results. All countries are organized in the same format. So far, I Am stumped. Any suggestion?
The workbook has about 50 countries and updated on daily basis. I would like to use the workbooks as it is and use formula (not VBA) to solve the problem.
Thank you.
Country A | ||||
2013 | 2012 | 2011 | 2010 | |
January | 1.00000 | 1.02000 | 1.04000 | 1.06000 |
February | 1.01000 | 1.03000 | 1.05000 | 1.07000 |
March | 1.02000 | 1.04000 | 1.06000 | 1.08000 |
April | 1.03000 | 1.05000 | 1.07000 | 1.09000 |
May | 1.04000 | 1.06000 | 1.08000 | 1.10000 |
June | 1.05000 | 1.07000 | 1.09000 | 1.11000 |
July | 1.06000 | 1.08000 | 1.10000 | 1.12000 |
August | 1.07000 | 1.09000 | 1.11000 | 1.13000 |
September | 1.08000 | 1.10000 | 1.12000 | 1.14000 |
October | 1.09000 | 1.11000 | 1.13000 | 1.15000 |
November | 1.10000 | 1.12000 | 1.14000 | 1.16000 |
December | 1.11000 | 1.13000 | 1.15000 | 1.17000 |
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
What Would I Like to Do:
On a separate sheet, I want to choose the country name, year and month and pull the corresponding results. All countries are organized in the same format. So far, I Am stumped. Any suggestion?
The workbook has about 50 countries and updated on daily basis. I would like to use the workbooks as it is and use formula (not VBA) to solve the problem.
Thank you.