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 tho 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.
