Try to search for a value for a given line, but want to create an ARRAYFORMULA so that whenever a new line is added, the search will be performed on that line.
We are currently using = IF (COUNTIF ($ A2: $ EI2, "=" & EO $ 1)> 0,1,0) to search for the line and if the value is found at least once, return 1, otherwise return 0 In this way, I have a value to reference for a conditional trigger elsewhere. The problem is that to apply this to a new line, I have to drag it down. The sheet is populated by responses to Google Form. So I'm going to have an indeterminate number of lines and I want the formula to work automatically on future lines without having to drag it.
Is there a way to perform a line search as ARRAYFORMULA? If it helps, I do not really need to look in the entire line, I only need to look in all the columns with some header (the header is the same as the question is repeated in the form because the respondents will not complete each section of the form).