Forum Discussion
Solved
Need help with formula for returning column headers
Hi guys Please see example sheet - https://docs.google.com/spreadsheets/d/1-1LY18tN8InO2CuFNLskEPnV9cSmjolQDse5GSZsNkQ/edit?usp=sharing I am trying to return the header (B2:F2) in I3 when a ...
The formula I managed to get working is this - =IFERROR(TEXTJOIN(",",,FILTER(Sheet2!A1:L1,MMULT(SEQUENCE(,ROWS(Sheet2!A2:L61)),--(Sheet2!A2:L61=S9))))," Not Located")
=IFERROR(INDEX($B$1:$F$1,SMALL(IF(MMULT({1,1,1,1,1,1,1,1,1},--($B$3:$F$11=$H$3)),COLUMN($A:$E)),1)),"")&IFERROR(INDEX($B$1:$F$1,SMALL(IF(MMULT({1,1,1,1,1,1,1,1,1},--($B$3:$F$11=$H$3)),COLUMN($A:$E)),2)),"")&IFERROR(INDEX($B$1:$F$1,SMALL(IF(MMULT({1,1,1,1,1,1,1,1,1},--($B$3:$F$11=$H$3)),COLUMN($A:$E)),3)),"")&IFERROR(INDEX($B$1:$F$1,SMALL(IF(MMULT({1,1,1,1,1,1,1,1,1},--($B$3:$F$11=$H$3)),COLUMN($A:$E)),4)),"")&IFERROR(INDEX($B$1:$F$1,SMALL(IF(MMULT({1,1,1,1,1,1,1,1,1},--($B$3:$F$11=$H$3)),COLUMN($A:$E)),5)),"")Maybe with this formula which works in my spreadsheet. Enter formula with ctrl+shift+enter if you don't work with Office365 or 2021.
The formula I managed to get working is this - =IFERROR(TEXTJOIN(",",,FILTER(Sheet2!A1:L1,MMULT(SEQUENCE(,ROWS(Sheet2!A2:L61)),--(Sheet2!A2:L61=S9))))," Not Located")