Help Querying Entire Column

Hi everyone, new user and Excel novice here and my first post. I am looking for a formula that will help me with the following.... I have a cell (A1) I would like to compare against an entire column (C:C). If cell A1 matches *any* of the cells in Column C I would like it to place the value of cell B1 into column D right next to the matching cell (otherwise the cell should remain blank). Note that there is is only *one* value in column A (A1), and *one* value in column B (B1). I can figure this out with dragging down a formula from D1 to all of the cells in the column but that is not what I want. I want the formula in cell D1 to dynamically check the entire length of column C without having to drag down the formula (similar to how vlookup works). Any help is appreciated!

-adk749

Looking to put a formula into column D that will output the value in B1, if and only if the value in column C matches the value in A1. Does that make better sense?

That formula works but I would like something I do not need to "copy down". I would like something that dynamically checks the entire column for me, that's where I am having trouble.

Looking for the formula to continually check down the column and compare each subsequent cell with A1.
For example, compare D1 with A1, then compare D2 with A1, then D3 with A1, and so on.
If the cell in column D matches with A1, I want it to output B1 for every match.

I have to imagine there is a way to accomplish this - forum experts don't fail me now :-).

Any type of solution would be greatly appreciated!