Compare 1 column with another column and match data in next column

Hi there,

I'm not sure ifor there is a function like this so that's why I'm asking. Is it possible to compare column A with column B and then tale the data in column C, that corresponds with the data in column B, and male it show up in column D? I have some of the same data in column A and B but each column has different
things missing, and the data in column C is part of the data fr column B, so I want to compare column A and B and if it matches then I want it to show the data in column D (column A and B are numbers as they and column C is text because it's a list of names). I hope that this makes sense to somebody as I am not sure what to do, if there isn't a function that helps with this I'm going to have to compare about 750 files individually.

Thanks so much to whomever helps!

Thanks for your help, tthis was exactly what I needed, all I had to do was lock the column values and then it worked perfectly!