I'm thinking a lookup type function would work for what I need, but I'm not
too familiar with that function, and what I tried didn't work. Any help
would be appreciated.

I have values in column C that Id like to find in column B, then copy the
data from column A in that corresponding row, and update column D with the
data from column A.

To clarify. . .

For example: In row one I have €˜123 in column C. I want to find €˜123 in
column B -- say its found in row two -- then copy the data from column A in
row two and paste it into column D in row one, where the formula originated.

Can this be accomplished?

Thank you.