Using index, match search with array formula for header row-CodePudding

I have working formula if I use this formula in every row. But my table is connected to google forms, so when new data is generated my formula shifts down as new row is created and doesn't work. So I need to put array formula to the header row, so that every time new row created, the array formula generates desired result.

=arrayformula(INDEX($E$2:$E$13,MATCH(1,SEARCH($E$2:$E$13,A2),-1))))

Not working formula for header array row:

=arrayformula(iferror(
              ifs(row(C:C)=1,"Header_array_formula",
                  isblank(A:A),"",
                  len(A:A)>0,INDEX($E$2:$E$13,MATCH(1,SEARCH($E$2:$E$13,A:A),-1))),""))

Here is link to my sample:

CodePudding user response：

try:

={"Header_array_formula"; 
 INDEX(PROPER(IFNA(REGEXEXTRACT(A2:A10, "(?i)"&TEXTJOIN("|", 1, E2:E)))))}