Add a condition to formula

[shimaa01234]

I want to add a condition column headers to this formula
=INDEX($J$2:$J$14; MATCH(1;INDEX(($A$2:$A$14=A2)*($B$2:$B$14=B2); 0; 1); 0))

CODE	NAME				max	Lowest		Value	Prev Close	Top Prev	Lower Prev
TASI	A	10579.1	10552.5	10579.1	10614.1	10551.8	224859251	8815489173	10552.4796	10585.38	10478.34
TBFSI	B	22315.2	22156.4	22315.2	22392.9	22156.4	29839018	809601079	22156.4141	22330.68	21889.48
1010	C	20.4	20.5	20.37	20.6	20.3	2139813	43758182.3	20.42	20.5	20.2
1020	D	35.8	36.3	35.93	36.4	35.7	1332312	48019290.2	35.73	36.6	35.6
1030	E	29.6	29.4	29.41	29.6	29.3	128900	3796487.9	29.4	29.8	28.9
1040	F	50	50.75	50.34	51	49.6	174496	8859296.25	50.79	51	50.25
1050	G	38.2	37.7	38.2	38.7	37.7	339394	13023813.4	37.45	38.4	36.8
1060	H	60	59	60	61	58.5	410280	24470740.5	58.63	60.25	58
1080	I	32.7	32.4	32.69	32.9	32.4	816712	26643985.8	32.29	33	32.1
1090	J	49.1	49.3	48.98	49.8	48.8	797451	39275828.7	49.49	49.7	48.9
1120	K	72.5	72	72.3	72.75	72	1984085	143645938	71.87	72.5	70.5
1140	L	48.3	48.2	48.31	48.7	48.1	629491	30503107.6	48.01	48.5	48
1150	M	20.55	20.2	20.5	20.6	20.15	21086084	427604409	20.18	20.25	20

<colgroup><col><col><col span="5"><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[cyrilbrd]

Hi,
Maybe something along '=INDEX(Whole_Range,MATCH(1,INDEX((Column_B=B2)*(Column_A=A2),0),0),MATCH(Cell_Reference_for_headers,Headers_Range,0))
Would that be what you referred to?

 

[shimaa01234]

Fantastic, Mister "cyrilbrd"
The formula works like a charm.
Thank you very much
More importantly, the answer, of interest in reply

 

[cyrilbrd]

Fantastic, Mister "cyrilbrd"
The formula works like a charm.
Thank you very much
More importantly, the answer, of interest in reply

Most welcome. Thank you for your feedback.