How to match two columns using if formula in excel

How to match two columns using if formula in excel

The process to match two columns using if formula in excel is available in this blog by which you can easily match two columns data and get result in true or false or as you want. If formula in excel is a very power full formula by which you can do so many smart work and reduce your time. Matching two columns is a just example of if formula in excel. First of all open excel work book where you want to apply this formula.

How to match two columns using if formula in excel
How to match two columns using if formula in excel

Where you want to show the result, just type the given formula and press enter button. Here A1 Represent the column that I want to match with B1, you can change the value as per your requirement.

How to match two columns using if formula in excel
How to match two columns using if formula in excel

=IF(A1=B1, TRUE, FALSE)

=IF(A2=B2, TRUE, FALSE)

=IF(A3=B3, TRUE, FALSE)

=IF(A4=B4, TRUE, FALSE)

=IF(A5=B5, TRUE, FALSE)

=IF(A6=B6, TRUE, FALSE)

=IF(A7=B7, TRUE, FALSE)

=IF(A8=B8, TRUE, FALSE)

You can see the result below, weather the columns matched, then the output is true otherwise false. You can alter this formula as per your requirement.

How to match two columns using if formula in excel Step 3
How to match two columns using if formula in excel Step 3

Related Posts