Excel – Compare data of two different columns – IF Function

Sometime we need to compare the data of two different columns in excel. Here is very simple solution with the help of IF Function.

Syntax:

IF (logical_condition, value_if_true, value_if_false)

Example:

Say we have two columns as

Excel – Compare data of two different columns

Now we can use the IF function as IF (A1=B1, TRUE, FALSE)

Excel – Compare data of two different columns

According to our IF condition if the data value of column A and column B are equal/matched then “True” value will be displayed in the  Column C otherwise “False” will be displayed.

If this post helps you then please comment.