How to compare two cells for text to return a value
I have created a help column named Match. I want to look at 2 cells, check to see if the text is the same and return a text string of "Match' or "No Match".
=IF(([Original Team]:[Original Team]@cell),NOT([New Team]:[New Team]@cell, "Not Match", "Match"))
I keep getting an #UNPARSEABLE error.
Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!