How to compare two cells for text to return a value

Justin Mauzy

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.

Andrée Starå

Hi @Justin Mauzy

Try something like this.

=IF(OR([Original Team]@row = "", [New Team]@row = ""), "", IF([Original Team]@row = [New Team]@row, "Match", "Not Match"))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Justin Mauzy

Try something like this.

=IF(OR([Original Team]@row = "", [New Team]@row = ""), "", IF([Original Team]@row = [New Team]@row, "Match", "Not Match"))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Justin Mauzy

That worked perfectly. Thank you!

Andrée Starå

@Justin Mauzy

Excellent!

You're more than welcome!