Hello.
I have tab COSTS which has employees and various $ amounts for those employees.
On tab EMP DATA I have the employee's departments.
I want to use a formula that will lookup go out and lookup all of the employee's departments and then list the total by department.
What I am trying not to do is add the VLOOKUP to costs to pull in the department. I was hoping to use a formula but just allow someone to copy and paste new raw data and it would just magically happen.
I have tab COSTS which has employees and various $ amounts for those employees.
On tab EMP DATA I have the employee's departments.
I want to use a formula that will lookup go out and lookup all of the employee's departments and then list the total by department.
What I am trying not to do is add the VLOOKUP to costs to pull in the department. I was hoping to use a formula but just allow someone to copy and paste new raw data and it would just magically happen.
SBC Marco.xlsm
drive.google.com