I have 3 data columns. Column A has 100 data cells, Column C has 25 data
cells, Column D has 25 data columns (related to column C).

I would like to compare Column A to C and if there is a match, put Column D
value in Column B, otherwise leave it blank.

Any help would be great!

Thanks!