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")
New contributor
Rupesh Sukale is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.