find non zero cell and then give output from cell just above

[patanjali]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Z[/TD]
[TD]Y[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi,

Could you please help me develop a formula for each row as per condition below.

In each row: There is only one cell with value greater than >0. I want to use a formula for each row that picks up which column has a value >0 and then picks up value from Header row.

For example, in row B: first cell is >0, so output should be Z. In row C, since cell X has value >0, it should be give X as output.

 

[Aladin Akyurek]

If each record contains just a single numeric value:

=LOOKUP(9.99999999999999E+307,B2:D2,$B$1:$D$1)

Otherwise:

=INDEX($B$1:$D$1,MATCH(TRUE,ISNUMBER(B2:D2),0))

which must be confirmed with control+shift+enter, not just enter.

Are you really wanting > 0, that is, wanting to avoid values like -4 or 0?