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: