Excel 2007 : Matching Stock Codes - SOLVED :)

Good Afternoon All,

Just wondering if I could have a moment of your time to help me with my problem! It is a little difficult to explain. I would appreciate any help with my problem.

We are a distribution company - we buy our products from China (VT-SZ) and then sell these within the European market. However along the way, when developing our systems (VT-UK) our stock codes have never been matched; between our own and in China.

This is causing us some issues as it is difficult to track incoming orders.

I have attached an excel spreadsheet. The first page shows stock codes from China (VT-SZ) and the second page shows the stock codes from us, VT-UK.
I am trying to match these two stock codes, so that our stock codes (VT-UK) and China's (VT-SZ) collerate.

Unfortunately we are using slightly different material descriptions for the same product; which makes any vlookup difficult to accomplish. I have tried braking down the stock descriptions to its basic form and then matching these up, but is proving more difficult than I first thought.

My question is, can you shed any light as to how to match up our stock codes, without having to go through each line by hand?

I have completed one item for example (line 197):

VT-UK Stock Codes VT-SZ Stock Code Material Type
1610 47LA04HHN1824 VT-47 core 0.10mm & 18/18 HTE 18"G*24"

Any questions or queries please let me know.

Kindest Regards,
Steve