Hello
I am quite new to using excel, I am trying to prepare a small program which requires me to use the values from a table by matching the imputted values with the ones in the x and y axises from the table. Is there a simple function like if or else if which I can use or do I need to use VBA which again I am not quite familiar with. Can you please help me thanks
My table looks sometin likes this
<table style="border-collapse: collapse; width: 469px; height: 182px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 68pt;" width="91"> <col style="width: 48pt;" span="2" width="64"> <col style="width: 68pt;" width="91"> <tbody><tr style="height: 24.75pt;" height="33"> <td class="xl66" style="height: 24.75pt; width: 68pt;" height="33" width="91">
</td> <td class="xl66" style="width: 48pt;" align="right" width="64">1000</td> <td class="xl68" style="width: 48pt;" width="64">1000-1500</td> <td class="xl69" style="width: 68pt;" width="91">1500+</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 68pt;" height="20" width="91">< than 5 years</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.13%</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.28%</td> <td class="xl67" style="width: 68pt;" align="right" width="91">3.44%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 68pt;" height="20" width="91">5-10 years</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.28%</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.45%</td> <td class="xl67" style="width: 68pt;" align="right" width="91">3.36%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 68pt;" height="20" width="91">over 10 years</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.36%</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.53%</td> <td class="xl67" style="width: 68pt;" align="right" width="91">3.70%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 68pt;" height="20" width="91">third party</td> <td class="xl66" style="width: 48pt;" align="right" width="64">670</td> <td class="xl66" style="width: 48pt;" align="right" width="64">800</td> <td class="xl66" style="width: 68pt;" align="right" width="91">2500</td> </tr> <tr style="height: 27.75pt;" height="37"> <td class="xl66" style="height: 27.75pt; width: 68pt;" height="37" width="91">compulasary excess</td> <td class="xl66" style="width: 48pt;" align="right" width="64">500</td> <td class="xl66" style="width: 48pt;" align="right" width="64">500</td> <td class="xl66" style="width: 68pt;" align="right" width="91">1000</td> </tr> </tbody></table>
now how to use the values like 3.13% in coulmn 1 by matching the user inputted values with the ranges given in x and y axis?
thanks in advance
vinay3744
I am quite new to using excel, I am trying to prepare a small program which requires me to use the values from a table by matching the imputted values with the ones in the x and y axises from the table. Is there a simple function like if or else if which I can use or do I need to use VBA which again I am not quite familiar with. Can you please help me thanks
My table looks sometin likes this
<table style="border-collapse: collapse; width: 469px; height: 182px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 68pt;" width="91"> <col style="width: 48pt;" span="2" width="64"> <col style="width: 68pt;" width="91"> <tbody><tr style="height: 24.75pt;" height="33"> <td class="xl66" style="height: 24.75pt; width: 68pt;" height="33" width="91">
</td> <td class="xl66" style="width: 48pt;" align="right" width="64">1000</td> <td class="xl68" style="width: 48pt;" width="64">1000-1500</td> <td class="xl69" style="width: 68pt;" width="91">1500+</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 68pt;" height="20" width="91">< than 5 years</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.13%</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.28%</td> <td class="xl67" style="width: 68pt;" align="right" width="91">3.44%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 68pt;" height="20" width="91">5-10 years</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.28%</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.45%</td> <td class="xl67" style="width: 68pt;" align="right" width="91">3.36%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 68pt;" height="20" width="91">over 10 years</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.36%</td> <td class="xl67" style="width: 48pt;" align="right" width="64">3.53%</td> <td class="xl67" style="width: 68pt;" align="right" width="91">3.70%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 68pt;" height="20" width="91">third party</td> <td class="xl66" style="width: 48pt;" align="right" width="64">670</td> <td class="xl66" style="width: 48pt;" align="right" width="64">800</td> <td class="xl66" style="width: 68pt;" align="right" width="91">2500</td> </tr> <tr style="height: 27.75pt;" height="37"> <td class="xl66" style="height: 27.75pt; width: 68pt;" height="37" width="91">compulasary excess</td> <td class="xl66" style="width: 48pt;" align="right" width="64">500</td> <td class="xl66" style="width: 48pt;" align="right" width="64">500</td> <td class="xl66" style="width: 68pt;" align="right" width="91">1000</td> </tr> </tbody></table>
now how to use the values like 3.13% in coulmn 1 by matching the user inputted values with the ranges given in x and y axis?
thanks in advance
vinay3744