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

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jun 15, 2023

Yash9154 

=INDEX($B$1:$L$1,SMALL(IF($B2:$L2>0,COLUMN($B$1:$L$1)-1),1))

An alternative for Excel 2013 could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.