Match text in A1 to a part of a text string in B1 and enter data D1

[markDuffy]

Hi Guys
Yesterday I go some great help from Norie and Oeklere which I have incorporated into this macro.
I am uploading a workbook which has 4 sheets
1. How I would like the file to look:
2. List of actions: (this is a step by step list of what I have done so far.
3. BankDownLoadConvertor: This is the part done sheet. You will see that the columns Company (D) and category (E) are not filled in.
4. Control sheet: this is where I have my tables. I don’t know if this is the normal way to store tables and am open to hearing what is the professional way to.
There are two tables
1. CompanyCategoryTrial which is a list of all companies and matching categories. Although this is made up from these companies I will be able to add to and use it continuously.
2. Account type which I have used to enter the account type.

In the sheet “How the file should look” the entries are made. These I have done by hand as I had to get the accounts filed. When the file is sent from the bank the bank descriptions are not always the same. There is always the name of the company contained within the text. What I need to do is somehow match the company name which is in my table “CompanyCatTrial” with the company name within the text string. I have tried =match( and whereas that does match some there are loads it does not. Looking at them I cannot fathom out why. I have spent the day trying to figure out how searching for a solution on the Web because I don’t want you guys to think I am asking you every question as it comes along. Perhaps my time would have been better spent doing more studying instead of jumping in half ****.
I hope someone will be able to make a suggestion.
Mark



Moderator's Note: I deleted your attachment due to sensitive data. Please upload another one.
Regards,
Vladimir