=ARRAYFORMULA({"test"; IF(AND(M2:M>=80,LEFT(H2:H,2)>=20),"Yes","No")})

My formula isn't expanding beyond the first cell. Not sure what I'm missing.

CodePudding user response：

AND() operation is applied to all values of column and returning single result. Use dynamic array formula to return result as separate value. Try MAP() function like-

={"Test";MAP(A2:INDEX(A2:A,COUNTA(A2:A)),B2:INDEX(B2:B,COUNTA(A2:A)),LAMBDA(a,b,IF(AND(a>=80,LEFT(b,2)>=20),"Yes","No")))}