Hi All,
Probably a simple question, but I need to use a match and index, but I've never used them before.
I need to look up the years and then look up the month and provide a value
For example
1 year and 5 months would produce 1.1556
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Years[/TD]
[TD]Monnth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD].0722[/TD]
[TD].1444[/TD]
[TD].2167[/TD]
[TD].2889[/TD]
[TD].3611[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD].8667[/TD]
[TD].9389[/TD]
[TD]1.00111[/TD]
[TD]1.0834[/TD]
[TD]1.1556[/TD]
[TD]1.2278[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Probably a simple question, but I need to use a match and index, but I've never used them before.
I need to look up the years and then look up the month and provide a value
For example
1 year and 5 months would produce 1.1556
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Years[/TD]
[TD]Monnth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD].0722[/TD]
[TD].1444[/TD]
[TD].2167[/TD]
[TD].2889[/TD]
[TD].3611[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD].8667[/TD]
[TD].9389[/TD]
[TD]1.00111[/TD]
[TD]1.0834[/TD]
[TD]1.1556[/TD]
[TD]1.2278[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]