How To Find Common Part Of Two Columns Using Vlookup In Excel

Suppose you have two columns of data. Doesn’t matter what kind of data they contain. Let it be customers and employees. You want to find common part of these two columns.

Column A – name of your clients

Column B – your employees

Column C – common part of these the collections of data.

Your task is to check if your employees are your clients as well.

Answer: Use such a formula:

=IF(ISERROR(VLOOKUP(B2,$A$1:$A$100,1,0)),””,VLOOKUP(B2,$A$1:$A$100,1,0))

Just copy that formula in C2 cell and drag it down.

Vlookup common part of collection

Template

You can download the Template here – Download