Data formula

Hi!  Hello! I want to create a complex formula and wonder how you solved it. In the excel sheet for investments, I have added a department and a person who is responsible for each purchase. Each y...