I’m trying to match up data between two excel files. In Book 1 I have a list of Companies Names that i want to indicate if they appear in the Companies Name list in Book 2.
If there is a match then in Book 1 on column B a “Y” should be recorded. If there is no match a “N” should be recorded.
Further it should take account of variations between Ltd or Limited. So that if in Book 1 a Company is called “Company 2 Limited” the process should still match it up with “Company 2 Ltd” in Book 2. The same will also be true if in Book 1 a Company is called “Company 3 Ltd” the process should still match it up with “Company 3 Limited” in Book 2.
I can setup the data tables and the variables but get stuck when it comes to the actual comparison. I have started with a For Each Row Activity for dtBook1 and inside another For Each Row Activity for dtBook2. I’ve then added an If Activity to compare the two Company Name strings. I’m unsure where to go from here though.