Forum Discussion

lucadefre's avatar
lucadefre
Copper Contributor
Aug 09, 2021
Solved

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

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.TLPH + SDLPH.artOROR.artOutput
NNNYNNLPH.art
NYNNNNLPH.T

 

Thank you for the help!

Best, 

 

Resources