I have 3 Excel files.
1) The master file
COLUMNS: ID, CellPhone Name, DataID1, DataID2
2) data set 1:
COLUMNS: ID, CellPhone Name
3) data set 2
COLUMNS: ID, CellPhone Name
What you'll need to do is find each cell phone name from the master file in the data files, get the ID used in the data files, and add both ID's to the master file.
I need this done manually because many of the names are similar but do not match exactly. For example "Apple iPhone 4S" vs. "iPhone 4 S"... it's the same, but the computer thinks they are different. So I need you to help me match them.
There is about 300 items in the master file.
I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I plan to use formula to match, then manual for those unmatched one, finally manually review all again. See my profile more in PM.
I am new to the Freelancer site, but have taken 2 classes in Excel as well as TA for both classes now. (Kelley School of Business) I have done many class files much more complicated than what you are asking, so this should't be a problem. Thank you for considering me.