- #COMPARE TWO COLUMNS IN EXCEL FOR MATCHES HOW TO#
- #COMPARE TWO COLUMNS IN EXCEL FOR MATCHES PROFESSIONAL#
The "table_array" and "column_index_num" is how you tell Excel where to look. This can be a cell reference or you can type a value. The "lookup_value", is what you're looking for or trying to compare. The syntax of the VLOOKUP formula is "=VLOOKUP(lookup_value, table_array, column_index_num, )". When you have more scattered data, the VLOOKUP algorithm can be more practical to use. Excel spreadsheet may not always have two side-by-side data lists for you to compare, which is where the IF algorithm is more practical. The IF function is efficient for simple and more beginner uses, but the VLOOKUP algorithm works better in more practical scenarios. Once you have the formula completed in cell "C3", you can drag the formula into the other columns by selecting cell "C3" and then clicking the bottom right of the cell and dragging down the column. If the value in cell "A2" is the same as in cell "B2", the formula outputs "Match" in cell "C3". If you have headers in the first row and your lists start from the second row, type the formula "=IF(A2=B2,"Match","Mismatch")" into cell "C2". If your information is in columns "A" and "B", you can put the formulas in column "C".
#COMPARE TWO COLUMNS IN EXCEL FOR MATCHES HOW TO#
Here's how to use the IF function in Excel:Ĭreate a third column where you want to input your end values. The IF formula that returns "Match" when data values are the same and "Mismatch" when they're different is "=IF(A2=B2,"Match","Mismatch")". This way, you're able to choose the value that gets outputted when you get a match or difference. The basic structure of this method is using the "=" operator, but with the IF function. Using the IF function is a simple method of learning how to compare two columns in Excel. How to compare two columns in Excel using the IF function
In this article, we discuss the process of comparing two columns in Excel in various ways.
#COMPARE TWO COLUMNS IN EXCEL FOR MATCHES PROFESSIONAL#
Developing your knowledge of Excel can help you grow your professional knowledge to help you be more productive. When comparing columns, you can identify the main similarities and differences in a data set, highlight unique data or find specific comparative information quicker. Excel has many functions for manipulating and analysing data, and the function to compare two columns is a useful feature for many use cases.