Is there an easy way to search two cells to see if they match?

Options

I've got two columns, ones a Contacts column with a drop down select, the other is a system column that is automatic and puts in the user email address.

Both populate via a form.

Is there a simple way to search both these columns and check if there's a match and display something like MATCH or NO MATCH?


Thanks.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!