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

Graham Rimell

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.

David Tutwiler

Do you want to see the rows that has a match side by side, or just whether there is a match at all on the sheet?

Graham Rimell

I'm looking to see if the cells match, and if they do report a yes or no.