HOW TO: "If cell contains a specific value, display name of the column in which value is present"?

[lucadefre]

Hi all, 

I am trying to write a code that finds a value in a row and displays the name of the column in which the value is present.

for example: the output should display the column name where "Y" is present in the selected row.

Let's consider the second row, the output should be LPH.art (i.e. column where Y is present)

LPH	LPH.T	LPH + SD	LPH.art	OR	OR.art	Output
N	N	N	Y	N	N	LPH.art
N	Y	N	N	N	N	LPH.T

Thank you for the help!

Best, 

[#2 · Accepted solution]

@lucadefre 

One option:

=INDEX(A$1:F$1,MATCH("Y",$A$2:$F$2,0))

[#3]

It worked, thank you for the help!