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

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

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.

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References