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

[patanjali]

	Z	Y	X
A		10
B	4
C			7
D	2

<tbody>
</tbody>

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?