-1

so I want to match couple in google sheet. Such that...

representation of my input nd output

Here, the XYZ and PQR are a match because both have written their names for each other. I wrote a formula, but it seems it is incorrect:

=ArrayFormula(if(D2:D278+F2:F278)=(F2:F278+D2:D278),"Match")

2 Answers 2

0

Here's one way:

=ARRAYFORMULA(IF((A2:A="")+(B2:B=""),,
   IF(COUNTIF(A2:A&B2:B,B2:B&A2:A),,"No ")&"Match"))

enter image description here

0

Another option :

=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(ISERROR(MATCH(B2:B&A2:A;A2:A&B2:B;0));"No Match";"Match"));COUNTA(A2:A);1)

GS

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.