Find matches between two columns to insert third but related information into a new column

Hello,

I have the following problem. I have 3 columns A, B and C. Column A is very long and all entries are repeated very often. Column B and C have the same amount of rows. In column B every entry of column A is listed, but only one single time! Column C provides new information relating to column B.
Aim: I want to create a new column D. Column D will have the same amount of rows as column A. If an entry in A resembles an entry in B, the correlating entry in C (entry in the same row) shall be written in column D.
So to say I want to compare two columns with each other and if two entries match, a third information, in relation to one of the two columns, shall be written into an additional column.

Thanks so much for your help!!
kind regards
Daniel

I feel this could be accomplished with vlookup; and you did a good job explaining the problem, can you provide a mock sample spreadsheet (commented) though?

Dear Ace_XL and cnodnarb,

thanks very much for your replies. Unfortunately Ace_XL's suggestion doesn't work for me. I get #Name? in all cells of column D if I pull down.
I attach the file as requested.
Thanks again for your help!
All the best
D

Yes you're right. The formula works perfectly fine.
Thanks all of you again.
D

Hello,
Find matches between two columns to insert third but related information into a new column(BB)_.xlsx

I have an additional problem, following my thread earlier. Now I want to sum up values relating to the newly compiled information. I attached a new excel spreadsheet for visualization with comments. Everything stayed the same except columns D, F and G were added to the sheet.
The earlier compiled column E has the same entries as column C, only that the entries in column C appear only one single time. Column E has more rows, because the entries are often repeated in this column. The information in column E relate to the values in columns F and G.
Aim: I want to create new information for column D. All values (F and G) of one entry in C that relate to the same entries in E shall be added up in column D. That means whenever an entry in E matches the entry in C, the relating values to the entry in E (column F and G in the same row) shall be added up in the one cell next to the entry in C.
E.g. on the spreadsheet: LAM: the region LAM appears one time in column C, but x-times in column E. All values (column F and G in the same row) for each time LAM appears in E shall be added up in cell D2. Subsequently the same procedure for all regions in C have to be repeated.

Thanks so much for your help. My feeling says I have to use the “sumif” and “match” functions together, but unfortunately I have no idea how. Please ask if there are uncertainties. Abstract problems are very hard to describe.
All the best
Daniel