Merge two columns together with extra data from two separate spreadsheets

Hi if somebody could help me that would be great, I am a newbie in Excel so please go easy on me.

I have two separate spreadsheets in which the unique identifier is the code.
one sheet has the code and product decriptions in html
and the other sheet has the code and the product swatches in html
I need to bring one sheet into the other so that it corresponds with the code and also bring the colour information.
There are some missing product descriptions and missing colours.

What is the best we to do this?

I have attached some sample spreadsheets.

Help is very much appreciated

You can best solve this by using a normal vlookup() function.
in your example file "main", cell B2, enter something like the following:

Formula:

Please Login or Register  to view this content.

Note that you will need to have both sheets open while you enter the formula, and then you can point to all of the references as you type.

It will update if something changes, and you can further improve the formula to update for additions to the color swatch list by changing the reference to include all rows (like $A$2:$B$65000).