We have 4 spreadsheets (thousands of lines in each) containing automotive replacement parts that need to be matched up with our master spreadsheet of autos. I need someone that can:
1. Create formula's to match anything that is an exact match.
2. Make analytical decisions to correct data that could be preventing an exact match (extra spaces, miss-spelling, reversed order, etc..)
3. Return the results in 5 worksheets: Exact Matches, Matches with Light Manipulation (trim extra spaces, fix word order, change date from 2 digit to 4 digit, etc..), Matches with Heavy Manipulation (miss-spellings, multiple items on one line, etc..), Items in Master Sheet that were not a match to our 4 part list sheets, and Items in our 4 part lists sheets that were not a match to our master sheet.
This project is time sensitive and HIGHLY ACCURACY SENSITIVE, and needs to be returned in the quickest timeframe possible. We are available 8:30am to 4:30pm EST to answer any questions or help make any decisions in regards to the data.