101Excel Hacks
    Back to Blog
    Excel featuresHack 13
    data optimization
    Excel formula
    sense check

    How to Check If Two Excel Cells Contain Identical Values

    Excel Hack #13

    9 views
    1 min read
    2015-09-01
    How to Check If Two Excel Cells Contain Identical Values

    This is a quick and simple hack to check if the contents of two cells are equal. It returns a TRUE if this condition is met and FALSE if it is not met. Assuming the 2 cells are $A$1 and $B$2, the form...

    This is a quick and simple hack to check if the contents of two cells are equal. It returns a TRUE if this condition is met and FALSE if it is not met. Assuming the 2 cells are $A$1 and $B$2, the formula will read as follows:
    =$A$1 =$B$2

    Frequently Asked Questions