Excel Hack 13: Check if two cell values are equal
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