I think this problem is like that of mine. But I don't have the solution
Plz find attached dummy data.
Sheet1: Company Name and Details
Sheet2: Company Name
I need to partially compare Company Name in sheet2 with Company Name in sheet1 and output should be Company Name of sheet2)+ (Details)
E.g. Sheet1 Company Name: Spanish MountainGold
Details : Preciousmetals
Sheet2 Company Name: 1) Spanish Mountain 2) Spanish Inc
Output should be: Spanish Mountain Preciousmetals
Spanish Inc Preciousmetals
Bookmarks