Finding the same value in another column
 

Hi,

I have to sheets of vendor part numbers and vendor names from two different
companies. The task is to isolate the common vendors the two companies have.
Is there a function that will aid in this situation.


Thanks