Help with Match/Index formula

[Brustigian]

Hello, I'm asking for help with a Match/Index formula. The formula would find the correct factor in the table. The data in the table is AGE, RATE, & Factor. The data is arranged in the table with the AGE in the far left column. RATES are distributed in increments of 1/8ths in the top row. The FACTOR is located in the array. Example, what is the correct Factor for a person age 75 at an interest rate of 7.375? Answer: 0.382
Thank you for your interest, Bob

	3.000	3.125	3.250	3.375	3.500	3.625	3.750	3.875	4.000	4.125	4.250	4.375	4.500	4.625	4.750	4.875	5.000	5.125	5.250	5.375	5.500	5.625	5.750	5.875	6.000	6.125	6.250	6.375	6.500	6.625	6.750	6.875	7.000	7.125	7.250	7.375	7.500	7.625	7.750	7.875
62	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.524	0.508	0.491	0.475	0.459	0.443	0.427	0.411	0.395	0.384	0.374	0.364	0.353	0.343	0.332	0.322	0.312	0.302	0.293	0.283	0.274	0.264	0.255	0.246
63	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.530	0.514	0.498	0.482	0.466	0.449	0.433	0.417	0.401	0.391	0.380	0.370	0.360	0.349	0.339	0.329	0.318	0.309	0.300	0.290	0.281	0.271	0.262	0.253
64	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.536	0.520	0.504	0.488	0.472	0.456	0.440	0.423	0.407	0.397	0.387	0.376	0.366	0.356	0.345	0.335	0.325	0.316	0.306	0.297	0.288	0.278	0.269	0.260
65	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.542	0.526	0.510	0.494	0.478	0.462	0.446	0.430	0.414	0.403	0.393	0.383	0.373	0.362	0.352	0.342	0.332	0.322	0.313	0.304	0.294	0.285	0.276	0.267
66	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.549	0.533	0.517	0.501	0.485	0.469	0.453	0.437	0.421	0.411	0.400	0.390	0.380	0.369	0.359	0.349	0.338	0.329	0.320	0.310	0.301	0.292	0.283	0.274
67	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.556	0.540	0.524	0.508	0.492	0.476	0.460	0.444	0.429	0.418	0.408	0.397	0.387	0.376	0.366	0.355	0.345	0.336	0.326	0.317	0.308	0.299	0.290	0.281
68	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.562	0.547	0.531	0.515	0.499	0.483	0.468	0.452	0.436	0.425	0.415	0.404	0.394	0.383	0.373	0.362	0.351	0.342	0.333	0.324	0.315	0.306	0.297	0.288
69	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.569	0.553	0.538	0.522	0.506	0.491	0.475	0.459	0.443	0.433	0.422	0.411	0.401	0.390	0.379	0.369	0.358	0.349	0.340	0.331	0.322	0.313	0.304	0.295
70	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.576	0.560	0.544	0.529	0.513	0.498	0.482	0.467	0.451	0.440	0.429	0.419	0.408	0.397	0.386	0.376	0.365	0.356	0.347	0.338	0.329	0.320	0.311	0.302
71	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.583	0.568	0.552	0.537	0.521	0.506	0.490	0.475	0.459	0.448	0.438	0.427	0.416	0.406	0.395	0.384	0.374	0.365	0.356	0.346	0.337	0.328	0.319	0.310
72	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.591	0.575	0.560	0.545	0.529	0.514	0.498	0.483	0.467	0.457	0.446	0.436	0.425	0.414	0.404	0.393	0.383	0.374	0.364	0.355	0.346	0.337	0.328	0.319
73	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.599	0.583	0.568	0.552	0.537	0.522	0.506	0.491	0.475	0.465	0.454	0.444	0.434	0.423	0.413	0.402	0.392	0.383	0.373	0.364	0.355	0.346	0.337	0.327
74	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.606	0.591	0.575	0.560	0.545	0.530	0.514	0.499	0.484	0.473	0.463	0.452	0.442	0.432	0.421	0.411	0.401	0.391	0.382	0.373	0.364	0.355	0.345	0.336
75	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.614	0.598	0.583	0.568	0.553	0.537	0.522	0.507	0.492	0.481	0.471	0.461	0.451	0.440	0.430	0.420	0.410	0.400	0.391	0.382	0.373	0.363	0.354	0.345
76	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.622	0.607	0.592	0.577	0.562	0.547	0.531	0.516	0.501	0.491	0.481	0.470	0.460	0.450	0.440	0.429	0.419	0.410	0.401	0.392	0.383	0.373	0.364	0.355
77	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.631	0.616	0.601	0.586	0.571	0.556	0.541	0.526	0.510	0.500	0.490	0.480	0.469	0.459	0.449	0.439	0.428	0.419	0.410	0.401	0.392	0.383	0.375	0.366
78	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.640	0.625	0.610	0.595	0.580	0.565	0.550	0.535	0.520	0.510	0.499	0.489	0.479	0.469	0.458	0.448	0.438	0.429	0.420	0.411	0.402	0.394	0.385	0.376
79	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.648	0.633	0.618	0.604	0.589	0.574	0.559	0.544	0.529	0.519	0.509	0.498	0.488	0.478	0.468	0.457	0.447	0.438	0.430	0.421	0.412	0.404	0.395	0.386
80	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.657	0.642	0.627	0.612	0.598	0.583	0.568	0.553	0.539	0.528	0.518	0.508	0.498	0.487	0.477	0.467	0.457	0.448	0.439	0.431	0.422	0.414	0.405	0.397
81	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.665	0.651	0.636	0.621	0.607	0.592	0.578	0.563	0.549	0.539	0.529	0.518	0.508	0.498	0.488	0.478	0.468	0.459	0.451	0.442	0.434	0.425	0.417	0.408
82	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.674	0.659	0.645	0.631	0.616	0.602	0.588	0.573	0.559	0.549	0.539	0.529	0.519	0.509	0.499	0.489	0.479	0.471	0.462	0.454	0.445	0.436	0.428	0.419
83	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.682	0.668	0.654	0.640	0.625	0.611	0.597	0.583	0.569	0.559	0.549	0.540	0.530	0.520	0.510	0.500	0.491	0.482	0.473	0.465	0.456	0.448	0.439	0.431
84	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.690	0.676	0.663	0.649	0.635	0.621	0.607	0.593	0.579	0.570	0.560	0.550	0.541	0.531	0.521	0.512	0.502	0.493	0.485	0.476	0.468	0.459	0.451	0.442
85	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.699	0.685	0.671	0.658	0.644	0.630	0.617	0.603	0.589	0.580	0.570	0.561	0.551	0.542	0.532	0.523	0.513	0.505	0.496	0.488	0.479	0.470	0.462	0.453
86	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.709	0.695	0.682	0.668	0.655	0.641	0.628	0.615	0.601	0.592	0.582	0.573	0.564	0.554	0.545	0.535	0.526	0.518	0.509	0.501	0.492	0.484	0.476	0.467
87	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.719	0.706	0.692	0.679	0.666	0.653	0.639	0.626	0.613	0.604	0.594	0.585	0.576	0.567	0.557	0.548	0.539	0.531	0.522	0.514	0.506	0.498	0.489	0.481
88	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.729	0.716	0.703	0.690	0.677	0.664	0.651	0.638	0.625	0.615	0.606	0.597	0.588	0.579	0.570	0.561	0.552	0.544	0.536	0.528	0.519	0.511	0.503	0.495
89	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.739	0.726	0.714	0.701	0.688	0.675	0.662	0.649	0.636	0.627	0.618	0.609	0.600	0.592	0.583	0.574	0.565	0.557	0.549	0.541	0.533	0.525	0.517	0.509
90	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.737	0.724	0.711	0.699	0.686	0.673	0.661	0.648	0.639	0.630	0.622	0.613	0.604	0.595	0.586	0.578	0.570	0.562	0.554	0.546	0.539	0.531	0.523
91	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.737	0.724	0.711	0.699	0.686	0.673	0.661	0.648	0.639	0.630	0.622	0.613	0.604	0.595	0.586	0.578	0.570	0.562	0.554	0.546	0.539	0.531	0.523
92	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.737	0.724	0.711	0.699	0.686	0.673	0.661	0.648	0.639	0.630	0.622	0.613	0.604	0.595	0.586	0.578	0.570	0.562	0.554	0.546	0.539	0.531	0.523
93	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.737	0.724	0.711	0.699	0.686	0.673	0.661	0.648	0.639	0.630	0.622	0.613	0.604	0.595	0.586	0.578	0.570	0.562	0.554	0.546	0.539	0.531	0.523
94	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.737	0.724	0.711	0.699	0.686	0.673	0.661	0.648	0.639	0.630	0.622	0.613	0.604	0.595	0.586	0.578	0.570	0.562	0.554	0.546	0.539	0.531	0.523
95	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.737	0.724	0.711	0.699	0.686	0.673	0.661	0.648	0.639	0.630	0.622	0.613	0.604	0.595	0.586	0.578	0.570	0.562	0.554	0.546	0.539	0.531	0.523
96	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.737	0.724	0.711	0.699	0.686	0.673	0.661	0.648	0.639	0.630	0.622	0.613	0.604	0.595	0.586	0.578	0.570	0.562	0.554	0.546	0.539	0.531	0.523
97	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.737	0.724	0.711	0.699	0.686	0.673	0.661	0.648	0.639	0.630	0.622	0.613	0.604	0.595	0.586	0.578	0.570	0.562	0.554	0.546	0.539	0.531	0.523
98	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.737	0.724	0.711	0.699	0.686	0.673	0.661	0.648	0.639	0.630	0.622	0.613	0.604	0.595	0.586	0.578	0.570	0.562	0.554	0.546	0.539	0.531	0.523
99	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.750	0.737	0.724	0.711	0.699	0.686	0.673	0.661	0.648	0.639	0.630	0.622	0.613	0.604	0.595	0.586	0.578	0.570	0.562	0.554	0.546	0.539	0.531	0.523

<tbody>
</tbody>

 

[bnj1776]

If you add Age as a column heading an turn it into a table named "Table1" then you would have:

=Index(Table1["7.375"], Match("75", Table1[Age], 0))

 

[L. Howard]

With Ages in A4:A41
With Rates in B3:AO3
Factors in B4:AO41
Formula in D1

=INDEX(B4:AO41,MATCH(A1,A4:A41,0),MATCH(B1,B3:AO3,0))

Put an age in A1 and a Rate in B1

A1 & B1 can be drop downs with the ages & rates, so you could just select from each drop down for a Factor.

Howard

 

[Brustigian]

Hi Howard, yes this works well! Thank you, Bob