tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
Please help if you can,
I have a list of businesses in coulnm H
and a list of Names in Column AA
now the Names in column AA area unique but can be more than one word like "Boots Ltd"
The words in Column H are full company names so are more complex like "Southend High Street Boots"
Now what would be ideal is if i could get a macro to check each line in H for a match in column AA and give the column it matched with and the type of match
For example
in H
""Southend High Street Boots Ltd" is an exact match to "Boots Ltd" so in column I i get the row number so say 17 and in Column J i get Matched
but if it said
""Southend High Street Boots" is not an exact match to "Boots Ltd" so in column I i get the row number so say 17 and in Column J i get Part Matched
i dont mind if this is a acro or formula, it is a one off run so can be slow, just need the help thanks
Tony
Please help if you can,
I have a list of businesses in coulnm H
and a list of Names in Column AA
now the Names in column AA area unique but can be more than one word like "Boots Ltd"
The words in Column H are full company names so are more complex like "Southend High Street Boots"
Now what would be ideal is if i could get a macro to check each line in H for a match in column AA and give the column it matched with and the type of match
For example
in H
""Southend High Street Boots Ltd" is an exact match to "Boots Ltd" so in column I i get the row number so say 17 and in Column J i get Matched
but if it said
""Southend High Street Boots" is not an exact match to "Boots Ltd" so in column I i get the row number so say 17 and in Column J i get Part Matched
i dont mind if this is a acro or formula, it is a one off run so can be slow, just need the help thanks
Tony