Matching up codes

[torquay]

Hi, not sure if there is anything that can be done.
I receive a list from my supplier in excel each week with model numbers in column C (usually about 40 rows) but they do not supply what those code mean (they are product codes). I have separate product list that I then have to match up. I match those code numbers up with the product they represent. i.e. C1 = Coffee Maker, C2 = Toaster etc. I then enter the product info in the next column D. The model numbers remain the same but there are new ones every couple of weeks.

A B C D
1 SAS SAS0540 D532W Coffee Maker
2 SAS SAS0540 DC543S Toaster
3 SAS SAS0540 DC543W
4 SAS SAS0540 DE2431FW

Hopefully this makes sense and would appreciate any help on this.
Thanks
Kim

 

[unmarkedhelicopter]

Sorry are you asking a question ?
If you want to list the product description in the model number list, then we would need the model list and the product list and we can show you how to link them.
Attach a spreadsheet and we'll take a look.

 

[torquay]

Thankyou for your reply but I have managed to figure it out by linking it to Access. Thanks again.