CODEWITHSUNDEEP
google-sheetsbooleangoogle-sheets-formulaarray-formulas
Elad Benda
Elad Benda

Reputation: 36664

ArrayFormula boolean AND return a false positive

I'm trying to create a AND boolean comparison.

It gives me same when different is expected:

=ARRAYFORMULA(IF(REGEXMATCH(K10:K, Q10:Q)*REGEXMATCH(L10:L, P10:P), "Same", "Different"))

as A == A but B != ""

enter image description here

Upvotes: 0

Views: 111

Answers (1)

player0
player0

Reputation: 1

try:

=INDEX(IF(L10:L&K10:K=P10:P&Q10:Q, "Same", "Different"))

Upvotes: 1

Related Questions