but most of them focus on searching in one column. In this tutorial, we will explore several techniques tocompare two columnsin Excel and find matches and differences between them.
SubExtendOffice_FindMatches()'UpdatebyKutoolsDimxRg,xRgC1,xRgC2,xRgF1,xRgF2AsRangeDimxIntSR,xIntER,xIntSC,xIntECAsIntegerOnErrorResumeNextSRg:SetxRgC1=Application.InputBox("Select first column:","Kutools for Excel",,,8)IfxRgC1IsNothingThenExitSubIfxRgC1.Columns.Count<>1ThenMsgBox"Please ...
Or you can display specific texts for showing matches or mismatches by using IF function like this: =IF(B2=C2,"Match","No match") The result may look like below: Example 2: Compare cells in the same row in case sensitive If you want to compare two columns row by row for case sensit...
Examples to Compare Two Columns for Matches Compare Two and Match Columns in Excel In this article, we will learn about Compare Two Columns in Excel for Match. Excel is the most potent tool on the planet, and we all will agree with this fact. We can do almost everything using Excel whe...
Example: Compare Two Columns and Highlight Matching DataOften, you’ll get datasets where there are matches, but these may not be in the same row.Something as shown below:Note that the list in column A is bigger than the one in B. Also some names are there in both the lists, but ...
To compare case-sensitive text strings, use the formula: =IF(EXACT(B7,C7),"Match","No Match")Only the exact matches with the right spellings and case sensitivities are matched.Case 1.3 – Comparing Date Values in ExcelIn the following dataset, we have a list of 10 projects along with ...
This tutorial demonstrates how to compare two columns for matches in Excel and Google Sheets. Compare Columns Side by Side If you have data in two columns that may or may not be adjacent to each other, you can use a formula in a third column to check to see if the data in the first...
Way 3. Using Vlookup Function (for Matches) The VLOOKUP function is the easiest function to compare the values of two columns and you can use it for the above example easily. It stands for "Vertical Lookup" and is used to search for a value in the leftmost column of a table and ret...
To compare two cells in Excel ignoring case, use a simple formula like this: =A1=B1 Where A1 and B1 are the cells you are comparing. The result of the formula are Boolean values TRUE and FALSE. If you want to output your own texts for matches and differences, embed the above statement...
In the example above, the value in cell B9 does not appear anywhere within the Column A range, so a count of zero is returned. Other ideas As you can see, Excel can excel compare two lists and return matches or differences using several simple methods. With a little imagination, some of...