Ok I am a web & graphic designer so i am not a pro with Excel. I have recently done a marketing sms campaign and i exported a scv file from The cloud software Netsuite, this is exported with each user having a unique internal id. So i then imported this into a bulk sms portal website. 5800 records imported. Now there is a reply service where they say yes. On the SMSportal i can export results as a excel file. But i lose all those internal id's. So the only way to identify who said yes is two put the two excel files together and identify the duplicates.

But what i need done is little more complicated. I need t first have the SMS exported file check the Netsuite one and find the duplicated once it identifies the duplicates it needs to copy all the columns right next to it or something? But i need all those columns so i can reimport it into netsuite and update the contact records so we can see who replied yes and have it on record.

Let me know if this makes sense???