Hello everyone

I don't know if I need a formula or a string of code to complete this task but I will explain what I am trying to accomplish

I have a column array with various cells in that array populated. In every subsequent cell in that array I want a formula that finds the previously populated cell and that value added a cell that is in the same row but two columns to the left.

PLEASE HELP!!!

Thanks
Joey