Use excel / sheets to check "match" of columns

If you need to see if one column matches another, use the function

We had to see if the words in one column were an exact match to the words in another column.

So we used this formula:

=IF(B5=E5, "Match", "No Match)")

Here is an example:

Screenshot 2025-06-04 at 6.07.51 am