Excel compare two cells

The quickest way to compare two cells is with a formula that uses the equal sign. If the cell contents are the same, the result is TRUE. (Upper and lower case versions of the same letter are treated as equal).

1. How do I compare two lists in Excel to find matches?

How do I compare two lists in Excel to find matches?

You can use the IF Function to compare two lists in Excel for matches in the same row. If Function will return the value TRUE if the values match and FALSE if they don't. You can even add custom text to display the word “Match” when a criterion is met and “Not a Match” when it's not met.