OK I have two similar Excel files say (file A and file B) for now.
I want two coloums from file A to be added to file B. But they must match in on other values in the other colums, some will be exact matches and some will be a little off and some could have no match at all.
So basically I want to match from each files so that I can add two colums. its pretty straight forward but im not great at explaining.I can add the two files when needed.
Time: I need this done for tmro night or Sunday morning at the latest. And I can pay first thing Monday. Anyone interested please get back to me asap. There is roughly 5,000 entries in each file which need to be matched up. I can explain more if needed.
Even if you could return me
[url removed, login to view] example a result with 4,500 entries matched perfectly on such a pattern
2.300 were partially matched
3. 200 could not be matched at all
Ther will be cases where it cant be matched so if you could narrow it down like this would be excelent
I understand a little about functions, sql, and that but I wanna see what would be best to do.