so I want to match couple in google sheet. Such that...
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")