Need a formula

[RAJESH1960]

Hello Guys

I am trying to get the values in column J with the help of a formula. Column J is the result entered manually which is as per the columns O to AH which have values and are not blank. I want to enter a column in column J where it will search the cells for values in O to AH and display the heading of that column.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1										Rate	Total	I	C	S	5	12	18	28	5	12	18	28	2.5	2.5	6	6	9	9	14	14	5	12	18	28
2										5	100		2.5	2.5	100								2.5	2.5
3										12	200		12	12		200									12	12
4										18	300		27	27			300										27	27
5										28	400		56	56				400											56	56
6										5	500	25							500												25
7										12	600	72								600												72
8										18	700	126									700												126
9										28	800	224										800												224
Sheet1

Cell Formulas
Range	Formula
K2:K9	K2	=SUM(O2:V2)
L2:L9	L2	=IF(SUM(AE2:AH2)=0,"",SUM(AE2:AH2))
M2:M9	M2	=IF(SUM(W2:AD2)/2=0,"",SUM(W2:AD2)/2)
N2:N9	N2	=IF(SUM(W2:AD2)/2=0,"",SUM(W2:AD2)/2)

 

[jasonb75]

=IFERROR(INDEX(O$1:AH$1,MATCH(J2,O2:AH2,0)),"")

 

[RAJESH1960]

Hello Guys

I am trying to get the values in column J with the help of a formula. Column J is the result entered manually which is as per the columns O to AH which have values and are not blank. I want to enter a column in column J where it will search the cells for values in O to AH and display the heading of that column.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1										Rate	Total	I	C	S	5	12	18	28	5	12	18	28	2.5	2.5	6	6	9	9	14	14	5	12	18	28
2										5	100		2.5	2.5	100								2.5	2.5
3										12	200		12	12		200									12	12
4										18	300		27	27			300										27	27
5										28	400		56	56				400											56	56
6										5	500	25							500												25
7										12	600	72								600												72
8										18	700	126									700												126
9										28	800	224										800												224
Sheet1

Cell Formulas
Range	Formula
K2:K9	K2	=SUM(O2:V2)
L2:L9	L2	=IF(SUM(AE2:AH2)=0,"",SUM(AE2:AH2))
M2:M9	M2	=IF(SUM(W2:AD2)/2=0,"",SUM(W2:AD2)/2)
N2:N9	N2	=IF(SUM(W2:AD2)/2=0,"",SUM(W2:AD2)/2)

Jasonb, Did you get the correct solution.? Because when I enter your formula I am getting all zeroes with a message which reads as
"There are one or more circular references where a formula refers to its own cell either directly or indirectly.This might cause them to calculate incorrectly."

Book1
	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1	Rate	Total	I	C	S	5	12	18	28	5	12	18	28	2.5	2.5	6	6	9	9	14	14	5	12	18	28
2	0	100		2.5	2.5	100								2.5	2.5
3	0	200		12	12		200									12	12
4	0	300		27	27			300										27	27
5	0	400		56	56				400											56	56
6	0	500	25							500												25
7	0	600	72								600												72
8	0	700	126									700												126
9	0	800	224										800												224
10
Query1

Cell Formulas
Range	Formula
J2:J9	J2	=IFERROR(INDEX(O$1:AH$1,MATCH(J2,O2:AH2,0)),"")
K2:K9	K2	=SUM(O2:V2)
L2:L9	L2	=IF(SUM(AE2:AH2)=0,"",SUM(AE2:AH2))
M2:M9	M2	=IF(SUM(W2:AD2)/2=0,"",SUM(W2:AD2)/2)
N2:N9	N2	=IF(SUM(W2:AD2)/2=0,"",SUM(W2:AD2)/2)

 

[jasonb75]

Typo

=IFERROR(INDEX(O$1:AH$1,MATCH(K2,O2:AH2,0)),"")

 

[RAJESH1960]

Typo

=IFERROR(INDEX(O$1:AH$1,MATCH(K2,O2:AH2,0)),"")

Got it. Thanks Jasonb