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

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

assumes columns are A-Z only!

"dan" wrote:

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

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



"dan" wrote in message
ps.com...
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

Maybe another way:

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

HTH,
Paul

--

"dan" wrote in message
ps.com...
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

On Aug 15, 12:12 pm, "Peo Sjoblom" wrote:
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

"dan" wrote in message

ps.com...



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- Hide quoted text -

- Show quoted text -

Thank you so much!!
Dan