Please advice: Automatic update of cell text based on the item number (also text)?

Greetings,

I have a column C with different text in cells (item's title). Column D - relevant description for each of the items. 100+ rows.

Now, unfortunately, often a spreadsheet with items is updated with many new items. So I get a new spreadsheet with old and new items mixed. I need, somehow, to import descriptions of the old items (Column D of the old spreadsheet) to the new spreadsheet from old spreadsheet. So I want excel to look for old items in column A of the new spreadsheet and, once found, insert a description in the column B from old spreadsheet.

Please see attachment

Example for forum.xlsx

Please help!

Thank you

Hello

In D5 and copy down use this.

Formula:

Please Login or Register  to view this content.

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

No worries for the rep!! You'll ought to me one!!