*HELP* Need a cell to return a column heading

[dan]

Hello - I am in need of a formula to return the value from a column
heading.

A B C MAX REF
1 0 3 3
1 2 1 2
0 0 0 0
3 0 1 3
2 0 3 3
2 0 3 3
1 0 2 2
0 2 0 2
1 0 2 2

In the REF column, I would like to lookup the value from the MAX
column and return the correct column heading.

So for example, the first REF cell would find the number 3 and return
the answer C.
The second cell down would find the number 2 and return the value B.

Thanks for any assistance someone can provide!
Dan

 

[Toppers]

=IF(MAX(A2:C2)<>0,LEFT(ADDRESS(1,MAX(A2:C2),2)),"")

assumes columns are A-Z only!

 

[Peo Sjoblom]

Assuming that A, B and C are real headers that you put there and not the
built in column headers

=INDEX($A$1:$D$1,MATCH(D2,$A2:$C2,0))

copy down

this assumes you A is in A1 and the first data starts in A2

if there is more than one value that matches it will return the first
occurrence

 

[PCLIVE]

Maybe another way:

=IF(OR(D1={"",0}),"",MID(ADDRESS(1,MATCH(D1,A1:C1)),2,1))

HTH,
Paul

 

[dan]

Assuming that A, B and C are real headers that you put there and not the
built in column headers

=INDEX($A$1:$D$1,MATCH(D2,$A2:$C2,0))

copy down

this assumes you A is in A1 and the first data starts in A2

if there is more than one value that matches it will return the first
occurrence

--
Regards,

Peo Sjoblom










- Show quoted text -

Thank you so much!!
Dan