WS 1 has multiple columns
WS 2 has 3 columns

WS 2:
companyname price/mth price/year
The common column is the company field.

I would like to combine the two WS and find out which company names are duplicated and add the other two columns to the same row. I am not sure if this is clear enough.


Is there a way to do that?