Extract Data from Table

[Santosh080]

Hello Friends,

I have a excel data like this,

Value of ROI ->	11.00	11.25	11.50	11.75	12.00	12.25	12.50	12.75	13.00	13.25	13.50
Value of n
6	1.056	1.058	1.059	1.060	1.062	1.063	1.064	1.065	1.067	1.068	1.069
12	1.116	1.118	1.121	1.124	1.127	1.130	1.132	1.135	1.138	1.141	1.144
18	1.179	1.183	1.187	1.192	1.196	1.201	1.205	1.210	1.214	1.219	1.223
24	1.245	1.251	1.257	1.263'	1.270	1.276	1.282	1.289	1.295	1.302	1.308
30	1.315	1.323	1.331	1.340	1.348	1.356	1.365	1.373	1.382	1.390	1.399
36	1.389	1.399	1.410	1.420	1.431	1.441	1.452	1.463	1.474	1.485	1.496
42	1.467	1.480	1.493	1.506	1.519	1.532	1.545	1.559	1.572	1.586	1.600
48	1.550	1.565	1.581	1.596	1.612	1.628	1.644	1.661	1.677	1.694	1.711
54	1.637	1.655	1.674	1.692	1.711	1.731	1.750	1.770	1.789	1.809	1.830
60	1.729	1.750	1.772	1.794	1.817	1.839	1.862	1.885	1.909	1.933	1.957
66	1.826	1.851	1.877	1.902	1.928	1.955	1.982	2.009	2.036	2.064	2.092
72	1.929	1.958	1.987	2.017	2.047	2.078	2.109	2.140	2.172	2.205	2.238
78	2.038	2.071	2.104	2.138	2.173	2.208	2.244	2.280	2.317	2.355	2.393
84	2.152	2.190	2.228	2.267	2.307	2.347	2.388	2.430	2.472	2.515	2.559
90	2.273	2.316	2.359	2.403	2.449	2.494	2.541	2.589	2.637	2.686	2.737
96	2.401	2.449	2.498	2.548	2.599	2.651	2.704	2.758	2.813	2.869	2.927
102	2.536	2.590	2.645	2.701	2.759	2.818	2.878	2.939	3.000	3.065	3.130
108	2.679	2.740	2.800	2.864	2.929	2.995	3.062	3.131	3.201	3.273	3.348
114	2.830	2.897	2.965	3.036	3.109	3.183	3.259	3.336	3.414	3.496	3.580
120	2.989	3.064	3.140	3.219	3.300	3.383	3.468	3.555	3.642	3.734	3.828

I want to extract a particular value from table when it match both value of n and ROI value. Like if Value of n= 42 and ROI= 12.25 then it should extract data =1.532

Thanks

 

[SunnyAlv]

Try

=SUMPRODUCT((A3:A22=O4)*(B1:L1=P4),B3:L22)

 

[MARK858]

A few more options

forum 9.2.2024.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Value of ROI ->	11	11.25	11.5	11.75	12	12.25	12.5	12.75	13	13.25	13.5
2	Value of n
3	6	1.056	1.058	1.059	1.06	1.062	1.063	1.064	1.065	1.067	1.068	1.069			120		13		3.642
4	12	1.116	1.118	1.121	1.124	1.127	1.13	1.132	1.135	1.138	1.141	1.144			72		12		2.047
5	18	1.179	1.183	1.187	1.192	1.196	1.201	1.205	1.21	1.214	1.219	1.223			42		12		1.519
6	24	1.245	1.251	1.257	1.263'	1.27	1.276	1.282	1.289	1.295	1.302	1.308
7	30	1.315	1.323	1.331	1.34	1.348	1.356	1.365	1.373	1.382	1.39	1.399
8	36	1.389	1.399	1.41	1.42	1.431	1.441	1.452	1.463	1.474	1.485	1.496
9	42	1.467	1.48	1.493	1.506	1.519	1.532	1.545	1.559	1.572	1.586	1.6
10	48	1.55	1.565	1.581	1.596	1.612	1.628	1.644	1.661	1.677	1.694	1.711
11	54	1.637	1.655	1.674	1.692	1.711	1.731	1.75	1.77	1.789	1.809	1.83
12	60	1.729	1.75	1.772	1.794	1.817	1.839	1.862	1.885	1.909	1.933	1.957
13	66	1.826	1.851	1.877	1.902	1.928	1.955	1.982	2.009	2.036	2.064	2.092
14	72	1.929	1.958	1.987	2.017	2.047	2.078	2.109	2.14	2.172	2.205	2.238
15	78	2.038	2.071	2.104	2.138	2.173	2.208	2.244	2.28	2.317	2.355	2.393
16	84	2.152	2.19	2.228	2.267	2.307	2.347	2.388	2.43	2.472	2.515	2.559
17	90	2.273	2.316	2.359	2.403	2.449	2.494	2.541	2.589	2.637	2.686	2.737
18	96	2.401	2.449	2.498	2.548	2.599	2.651	2.704	2.758	2.813	2.869	2.927
19	102	2.536	2.59	2.645	2.701	2.759	2.818	2.878	2.939	3	3.065	3.13
20	108	2.679	2.74	2.8	2.864	2.929	2.995	3.062	3.131	3.201	3.273	3.348
21	114	2.83	2.897	2.965	3.036	3.109	3.183	3.259	3.336	3.414	3.496	3.58
22	120	2.989	3.064	3.14	3.219	3.3	3.383	3.468	3.555	3.642	3.734	3.828
Sheet3

Cell Formulas
Range	Formula
S3	S3	=INDEX(B3:L22,MATCH(O3,A3:A22,0),MATCH(Q3,B1:L1,0))
S4	S4	=XLOOKUP(O4,A3:A22,XLOOKUP(Q4,B1:L1,B3:L22))
S5	S5	=VLOOKUP(O5, A3:L22, MATCH(Q5, A1:L1, 0), FALSE)

 

[Santosh080]

thank you very much