How to get commons values from two columns in Microsoft Excel?

About this Article -

In This Article i will show you How to get commons values from two columns in Microsoft Excel with two method Given below. so lets get Started.

In this method I am using VLOOKUP Function to get common values from two columns into 3rd column.

The Syntax of VLOOKUP function is given below

=VLOOKUP (lookup_value, table_array, col_num, [range_lookup])

VLOOKUP function is divided into four parts

lookup_value - lookup_value is a value that value by which we will match 1st column value. Here we choose B3 Cell as a lookup value.
Table_array - In this case table_array is the range of the columns from which we will extract common value by comparing 2nd column. After Selecting range of table_array you have to press F4 for Locking the range of table_array.
col_num - col-num is the number of the column from where we extract common value. In this case I am choosing column number 1 to extract common value because data inside the column is greater than that of column 2.
[range_lookup] - [range_lookup] has two option true or false. true for approximate match and False for exact match. Here i am choosing false for exact match.

After typing VLOOKUP press enter to get common values in the 3rd column.

In This method I am Using Conditional Formatting.
Select both Cell from where you want to extract common values.
Now click on Home>Conditional Formatting>Highlight Cell Rules>Duplicates Values
After Selecting Duplicate Value a Dialogue box will appear. Here you have to use Unique Values.
When you choose Unique Value you can see highlighted Common Value with your preferred formatting.

In this Article you have learnt to extract common values from two column in Microsoft Excel with VLOOKUP Function and Conditional Formatting.

Thank for Reading this article Follow this blog for more Tutorials,

Kindly support me by Sharing this blog and article.

Happy Learning...