Populate an empty column with descriptions from another spreadsheet if the code matches.

I have 2 spreadsheets of data. Common to both is a column of part numbers (Code *). One sheet is missing the full description and I would like to populate the empty column with the corresponding description from the other spreadsheet if it is there. (Some may be missing)
I have attached two sample sheets. I would like the description populated in Sample one from Sample two spreadsheet.
Many thanks.
Charles

It is easier to open both files in the same instance of Excel, and then you can use this formula in B2 of the Sample_One file:

=IFERROR(VLOOKUP(A2,'[Sample two - Descriptions complete.xlsx]PRICE RECORD.csc descriptions 1'!$A:$B,2,0),"")

Copy this down as far as you need to.

Hope this helps.

Pete

It works perfectly on my sample sheets but I'm having trouble applying it to the real sheets which are csv files and much bigger.
I am so sorry to ask but could you give me the formula again for the real sheets:
Sample two - Descriptons complete.xlsx = Two Descriptions complete.csv
Sample one - Description missing.xlsx = Assembly 1 Missing Description.csv (394802 rows)
Thank you so much.
Charley

The formula will become this:

=IFERROR(VLOOKUP(A2,'[Two Descriptions complete.csv]Sheet1'!$A:$B,2,0),"")

I presume the .csv file will have its sheet named Sheet1 when it is opened. Put the formula in B2 of the Assembly 1 file, then copy down.

Hope this helps.

Pete

P.S. If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Thank you so much! Have got it to work and it has saved a massive amount of time... star!