Compare two columns in excel 2010 and find matches
![compare two columns in excel 2010 and find matches compare two columns in excel 2010 and find matches](https://cdn.ablebits.com/_img-blog/compare-excel-files/view-differences.png)
Drag the formula down to the other cells in column C clicking and dragging the little “ +” icon on the bottom-right of C2.Insert the formula in “ =IF(ISERROR(VLOOKUP(A2,$B$2:$B$1001,1,FALSE)),FALSE,TRUE)” the formula bar.You can check if the values in column A exist in column B using VLOOKUP. The syntax for VLOOKUP is =VLOOKUP(value, table_array, col_index,).
COMPARE TWO COLUMNS IN EXCEL 2010 AND FIND MATCHES HOW TO
In this tutorial, we will look at how to use VLOOKUP on multiple columns with multiple criteria. VLOOKUP is one of the lookup, and reference functions in Excel and Google Sheets used to find values in a specified range by “row.” It compares them row-wise until it finds a match. Check if one column value exists in another column using VLOOKUP The NOT() and ISERROR() functions check for an error which would be and column C will show “True” for a match and “False” if it is not a match. If there is a match, it will return the row number.
![compare two columns in excel 2010 and find matches compare two columns in excel 2010 and find matches](https://www.excelsirji.com/wp-content/uploads/2019/12/71.31.png)
The VLOOKUP, HLOOKUP, INDEX and MATCH functions can make life a lot easier in terms of looking for a match. One of the most important features in Microsoft Excel is lookup and reference. When you need to check if one column value exists in another column in Excel, there are several options.