Forum Discussion

Yash9154's avatar
Yash9154
Copper Contributor
Jun 14, 2023
Solved

I want to find out header name on the basis of starting value of each row

Hi,   I want to find out header name on the basis of starting value of each rows.   For Example: as per below screenshot, the start point value in row 2 is from column G then in Column N the form...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Jun 15, 2023

    Hi Yash9154 

    Alternative with XLOOKUP (2021 & 365)

     

     

    in N2

    =XLOOKUP(TRUE, B2:L2 > 0, B$1:L$1, "No match")

     

    PS: There's a Search button on this site and other forums where the same question has been answered nnn times

Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 15, 2023

Hi Yash9154 

Alternative with XLOOKUP (2021 & 365)

 

 

in N2

=XLOOKUP(TRUE, B2:L2 > 0, B$1:L$1, "No match")

 

PS: There's a Search button on this site and other forums where the same question has been answered nnn times