Lookup partial match and enter that in another column same row

Hi Guys
Find match within in text string in Cell “D1” (Partial Match) and match to table then enter table entry into “D23”


I put up this Question a few days ago in an unclear form and with data I had to withdraw. Since then I have been trying to solve my need. So here it is broken down. Company name replaced by a country name.

I have a column which contains descriptions of transactions from the bank. Within these transactions are text strings which indicate who the payees are. These were not designed to be easily machine read but I am sure they can be.
Example:

Description______________________________________________________________________ Company
6138 24MAY11 , Chad Limited650238586
72588599/Afghanistan , 316-9424707 US , USD 9.95, RATE 1.5945, CHARGE 1.25, ERTF 0.17
'7974 23JUN11 , Albania



Description______________________________________________________________________ Company
6138 24MAY11 , Chad Limited650238586______________________________________________Chad
72588599/Afghanistan , 316-9424707 US , USD 9.95, RATE 1.5945, CHARGE 1.25, ERTF 0.17___Afghanistan
'7974 23JUN11 , Albania____________________________________________________________Albania

Eventually I will have much larger quantities of data.
I have tried Vlookup match without being able to see them.
The descriptions have several formats as you will see in the attached sample.
I have thought about trimming, removing the preceding apostrophe.
I have included a sheet showing some of my attempts.

What I would really like is some guidance or better still a function or VBA formula which I can study to understand and also use. I have put the data and the lookup table on the same sheet. Eventually I will want to have it on a control sheet.

I will now go back to trying to understand the previous posts. I know the answer is there but either have not been able to use them or have not found it yet.

Here's hoping
Mark