The formula is =IF(A2=B2,âMatchâ,âNot a Match â) The same formula can identify and return the mismatching values, but an additional result can be shown when the IF condition proves false. It returns the result as Match against the rows that contain matching values, and the remaining rows are left empty. The formula to compare two columns is =IF(A2=B2,âMatchâ,â â). In Excel, you can compare two columns using the IF condition. Compare Two Columns in Excel Using IF Condition The formula returns TRUE if the values in rows that are compared are the same and return FALSE if the values are different. Then, drag it down until the end of the table. In cell C2, insert the formula and press Enter. The formula =A2=B2 is used in the example below to find the matching data and the result returns as True or False. You can compare two columns, row by row, and find the matching data by returning the result as Match or Not Match.
0 Comments
Leave a Reply. |